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
+-------------------------------------------------------------------
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
+-------------------------------------------------------------------