|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 20th 12, 11:13 AM
|
|||
|
|||
SUMIF across 2 columns.
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 
|
| Ads |
|
#2
July 20th 12, 01:23 PM
|
|||
|
|||
|
Quote:
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Sumif On Two Columns of Data - How? | [email protected] | Excel Worksheet Functions | 3 | May 9th 08 09:33 PM |
| SUMIF across Columns | JICDB | Excel Worksheet Functions | 2 | May 7th 07 02:48 PM |
| Sumif across columns | mminsf | Excel Worksheet Functions | 8 | June 29th 05 11:46 PM |
| Sumif over multiple columns | Josh O. | Excel Worksheet Functions | 1 | February 15th 05 04:33 PM |
| SUMIF testing two columns... | lgarcia | Excel Worksheet Functions | 1 | November 25th 04 07:55 PM |
Linear Mode
