Sumif Function

Josh · Jul 21, 2003

Here is my formula:
=IF(E2<>E1,(SUMIF($E$2:$E$1000,E2,$BU$2:$BU$1000)+SUMIF
($E$2:$E$1000,E2,$CD$2:$CD$1000)+SUMIF
($E$2:$E$1000,E2,$DA$2:$DA$1000)),0)

Is there any way to have add a second criteria for the
sumif to function with?

Josh · Jul 22, 2003

Thanks for the help this is gonna work great.

-----Original Message-----
Josh,

This seems to work.

First change your formula to
=IF(E2<>E1,SUMPRODUCT(($E$2:$E$1000=E2)*(($BU$2:$BU$1000)+ ($CD$2:$CD$1000)+(
$DA$2:$DA$1000))),0)
make sure everything is still okay at this point.

Then add second condition
=IF(E2<>E1,SUMPRODUCT(($E$2:$E$1000=E2)* (range_to_test=value)*(($BU$2:$BU$10
00)+($CD$2:$CD$1000)+($DA$2:$DA$1000))),0)

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks

.