SUMIF across 2 columns.

V

VZBoon

Hi all,

Could somebody help me create a formula to sumif across two columns
Attached is an example. Columns F&G are columns A&B with remove
duplicates.

I am looking for the total values of C against each combination of A&B
In Red is the answer that I am trying to get to.


What formula can i put in column H to produce this result?

Thank

+-------------------------------------------------------------------
|Filename: SCREENSHOT.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=479
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif & Countif 6
how to get the total of two lines 3
Complicated Match Formula with conditions 2
Look UP formula for 2 and 3 conditions 1
Permanently link formula references to Column Names and not Column Cell Numbers 1
Index Match QUestion 0
Look UP and then caluclation with IS ERROR 3
If Function neglecting 0 as a number 1

Top