Sumif I Think

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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
 
Just a guess, but perhaps you are looking for this...

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

Rick
 
Try:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top