SUMProduct help

[Jeremy]

=SUMPRODUCT(($D$2:$D$23=$A28)*($C$2:$C$23>=10)*($e$2:$e$23,NONBLANK))

I knoe the first 2 legs of the formula work, i am already using them. all i
want to add in the new call is another criteria: that being when e2:e23 are
not blank.

What do I put where NONBLANK is in my formula?

 

[Mike H]

Perhaps

=SUMPRODUCT(($D$2:$D$23=$A28)*($C$2:$C$23>=10)*($E$2:$E$23<>""))

Mike

 

[Jeremy]

you are both a gentleman and a scholar.

one last issue before I have all the tols I need to finish this table.

I have =SUMPRODUCT(($D$2:$D$23=$A28)*($C$2:$C$23>=10)) right now.
I also need to count the second leg of the formula for all C2:C23 that are
greater than or equal to 5 but less than 10. I have tried every way of doing
this but can't nail it down.

Then I think I'll have it.

Thanks
Jeremy

 

[Don Guillett]

Just add another parameter
=SUMPRODUCT(($D$2:$D$23=$A28)*($C$2:$C$23>=5)*($C$2:$C$23<10))

 

[Mike H]

Your welcome and you have an answer to your follow up question from another
respondent