LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
rlandlin
 
Posts: n/a
Default SUMIF function with 2 conditions


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use IF function for two conditions wuwu Excel Worksheet Functions 3 April 29th 23 11:42 AM
I need help with the Sumif Function Mark Excel Worksheet Functions 3 May 4th 05 11:07 PM
SUMIF function yak10 Excel Worksheet Functions 0 February 12th 05 05:12 PM
SUMIF function yak10 Excel Worksheet Functions 3 February 12th 05 01:15 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM


All times are GMT +1. The time now is 12:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"