SumIf Question? If question? I'm stumped..

A

Adam

I have three columns. "A", "B", and "C". I want to sum column "C" when "A"
equals a specific value AND "B" equals a specific value.

For example, sum the amuunts in column "C" when "A" equals "ball" AND "B"
equals "bat".

Any ideas?

-Adam
 
A

Andrea Jones

You can use an array formula, you need to press CTRL+Shift+Enter after typing
the formula, if you've done this correctly curly brackets {} will appear
around the formula in the formula bar:

Use a formula something like:

=SUM(IF(($A$2:$A$6="ball")*($B$2:$B$6="bat"),$C$2:$C$6))

(it won't work if you don't press CTRL+SHIFT+ENTER to enter the formula)

A Jones
 
S

Sandy Mann

You can actually miss out the IF() form your formula and just have:

=SUM(($A$2:$A$6="ball")*($B$2:$B$6="bat")*$C$2:$C$6)

still array entered or make it a SUMPRODUCT() formula:

=SUMPRODUCT(($A$2:$A$6="ball")*($B$2:$B$6="bat")*$C$2:$C$6)

--
Regards

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
Top