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
Your formula is
=SUMPRODUCT((A1:A3=\"REVENUE\")*(B1:B3=\"HQ\")*C1: C3)
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=471440