The conditional sum wizard is always an option but this is a little easier:

=SUMPRODUCT(--(A1:A3="Revenue"),--(B1:B3="HQ"),C1:C3)

--
Regards,
Dave


"rlandlin" wrote:


Hi,
I need a function to give two conditions in a SUMIF formula and don't
get round it on my own.

I need to calculate e.g. if column A is Revenue and column B is HQ,
then sum up column C.

A B C
1 Revenue HQ 250
2 Revenue Loc 350
3 Expense HQ 450


Maybe it's not the SUMIF formula to solve the matter, but you know a
more suitable one, I'm happy to learn about it.

Thanks for you support,
Ruth


--
rlandlin
------------------------------------------------------------------------
rlandlin's Profile: http://www.excelforum.com/member.php...o&userid=27596
View this thread: http://www.excelforum.com/showthread...hreadid=471440