multiple Sum if variables

[Mile029]

Can I put two variables into a SumIF? forexample I want to sum Column C if Column A is equal to Apples and Column B is equal to Oranges, then sum Column C. Is there a quick formula?

[NBVC]

Try:

=Sumproduct(--(A1:A100="Apples"),--(B1:B100="Oranges"),C1:C100) ... can't use full columns with this formula in XL2003 and prior versions.

If you have XL2007

=SUMIFS(C:C,A:A,"Apples",B:B,"Oranges")

Note: Please update your profile to indicate your version.

[Mile029]

sumproduct, thanks, forgot about that one!

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save