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
|