Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use IF function for two conditions | Excel Worksheet Functions | |||
I need help with the Sumif Function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |