SUMProduct help
 

=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?

SUMProduct help
 

Perhaps

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

Mike

"Jeremy" wrote:

=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?

SUMProduct help
 

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



"Mike H" wrote:

Perhaps

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

Mike

"Jeremy" wrote:

=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?

SUMProduct help
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" <jeremiah.a.reynolds @ gmail.com wrote in message
...
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



"Mike H" wrote:

Perhaps

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

Mike

"Jeremy" wrote:

=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?

SUMProduct help
 

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

"Jeremy" wrote:

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



"Mike H" wrote:

Perhaps

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

Mike

"Jeremy" wrote:

=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?