Conditional sum on an array

[jeffbannister]

Hi,
I'm facing a problem that I thought would be simple. I'm trying to sum an array based on two conditions which sumif won't do. Here's an example
Apple Apple Banana Apple
Team1 1 1 1 1
Team1 1 1 1 1
Team2 1 1 1 1
Team3 1 1 1 1

So what I want to do is sum the 4x4 grid of '1's if the column is "apple" and if the Team is Team1.
I tried sumifs but it doesn't like the 4x4 array.
Any suggestions?
Thanks in advance,
Jeff

[teylyn]

Hello,

That's what Sumproduct does to perfection:

=SUMPRODUCT((A2:A5="Team1")*(B1:E1="Apple")*B2:E5)

cheers,

[MarvinP]

Hi Jeff and welcome to the forum,

If you had your data in what Excel calls a Table you could do a Pivot Table on it to get lots of these answers.

see the attached.