Sumif depending on two criteria

Shelly68

Board Regular
Joined
Sep 12, 2006
Messages
73
Complete novice here (well compared to everybody else on this forum, lol)

-----A ----- B ----- C

Apple -- -- Red -- 10
Apple ---- Green -- 6
Orange -- Blue -- 15
Orange -- Blue -- 20
Banana-- - Yellow -- 20
Banana -- Purple -- 10

How can I work out how many of each there are please
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

JohnnyTightlips

Board Regular
Joined
Aug 13, 2006
Messages
94
Hi, Welcome to the board

To work out Orange and blue using your example:

=sumproduct((a1:a6="orange")*(b1:b6="blue")*(c1:c6)) will result in 35
 

Watch MrExcel Video

Forum statistics

Threads
1,108,984
Messages
5,526,060
Members
409,682
Latest member
HisHailo

This Week's Hot Topics

Top