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

[Guest]

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

 

[Guest]

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

 

[Jim]

You can put this formula in C.

=SUM(IF(A=1, IF(B=2,A+B,"")))

 

[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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk