COUNT or SUM with multiple criteria
Biff, you RULE!! It worked perfectly!
"Biff" wrote:
Hi!
Do you want the count or the sum?
Count:
=SUMPRODUCT(--($A$1:$A$2500="CLE"),--($B$1:$B$2500="IE"),--($E$1:$E$2500=6),--($I$1:$I$2500<0))
Sum:
=SUMPRODUCT(--($A$1:$A$2500="CLE"),--($B$1:$B$2500="IE"),--($E$1:$E$2500=6),--($I$1:$I$2500<0),$I$1:$I$2500)
Biff
"Teri" wrote in message
...
Here is my current formula, but it is returning the wrong answer, so
obviously I'm doing something wrong.
I am looking for the number of negative dollars in the range I1:I2500 that
meets the other criteria. Can anyone please help?
=SUMPRODUCT(--($A$1:$A$2500="CLE"),--($B$1:$B$2500="IE"),--($E$1:$E$2500=6),$I$1:$I$2500<0)
|