Sumif I Think

Giganews Newsgroups
Subject: Sumif I Think
Posted by:  Paul (Msr…@TPx12.com)
Date: Fri, 25 Jul 2008

D  E  G  I

p  s  $2  $2
q  t  $2  $2
p  s  $2
r  y  $2
s  z  $2  $2
p  t  $2  $2

I have the following formula in a table which gathers data from the
example above..

=SUMPRODUCT(($D$15:$D$2000="P")*($E$15:$E$2000="S")*($G$15:$G$2000)*($I$15:$I$2000))

The problem is that in column I sometimes there isn't a dollar amount,
so the formula I have multiplies $2 x 0 and comes up with Zero.

Ex: I want to know the total dollar amounts for Items P that
correspond with Items S...answer should be $6

Thanks

Replies