Sum product is not working..... coming up with "0".

Any other ideas?

"Roger Govier" wrote:

Hi James

One way
=SUMPRODUCT(--($B$2:$B$5="Oranges"),--($C$2:$C$5="Blue"),$A$1:$A$5)

Regards

Roger Govier


James Hamilton wrote:
Hi,

I want to do a SUMIF but on more than one condition. For example:

A B C
3 Apple Green
4 Orange Blue
4 Pear Yellow
5 Orange Blue
6 Orange Red

I want to sum the amounts in column A, based on column B and C. In this
case, sum the amounts in column A for Oranges in column B and Blue in Column
C.

Any help would be appreciated.

James