ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   SUMIF across 2 columns. (https://www.excelbanter.com/excel-discussion-misc-queries/446623-sumif-across-2-columns.html)

VZBoon
SUMIF across 2 columns.
 
1 Attachment(s)
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 removed 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?

Thanks

Spencer101
Quote:
Originally Posted by VZBoon (Post 1603831)
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 removed 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?

Thanks
Excel 2003 or earlier use: =SUMPRODUCT((A$1:A$11=F1)*(B$1:B$11=G1),C$1:C$11)
Excel 2007 or later use: =SUMIFS(C$1:C$11,A$1:A$11,F1,B$1:B$11,G1)

Enter in H1 and copy down.


All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com