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
|
|||
|
|||
Sumif over multiple columns
I am trying to total some columns based on an invoice number, but I can't get
the formula to work. I have the following columns: Invoice 1|Amount1|Invoice2|Amount2|Invoice3|Amount3|Invoic e4|Amount4 In another column I have an invoice number. I need the formula to add the amount if the invoice column just to the left contains that invoice number, for each column. For example in A1 is invoice 1234. I need the formula to add all amounts from Columns Amount1, Amount2, Amount3, Amount4 if the corresponding Invoice column matches A1. I tried using the Sumif and Sumproduct, but it is only returning a #VALUE! error. |
#2
|
|||
|
|||
Hi Josh
one option =SUMIF(A2:A5,J1,B2:B5)+SUMIF(C2:C5,J1,D25)+SUMIF (E2:E5,J1,F2:F5)+SUMIF(G2:G5,J1,H2:H5) (i've put the criteria in J1) Cheers JulieD "Josh O." wrote in message ... I am trying to total some columns based on an invoice number, but I can't get the formula to work. I have the following columns: Invoice 1|Amount1|Invoice2|Amount2|Invoice3|Amount3|Invoic e4|Amount4 In another column I have an invoice number. I need the formula to add the amount if the invoice column just to the left contains that invoice number, for each column. For example in A1 is invoice 1234. I need the formula to add all amounts from Columns Amount1, Amount2, Amount3, Amount4 if the corresponding Invoice column matches A1. I tried using the Sumif and Sumproduct, but it is only returning a #VALUE! error. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Table combining multiple columns | Pete Petersen | General Discussion | 1 | January 13th, 2005 07:56 PM |
SUMPRODUCT with multiple columns to sum | Andy | Worksheet Functions | 2 | October 6th, 2004 10:15 AM |
Using multiple criteria in SUMIF & COUNTIF? | ScubaJoe13bitem | Worksheet Functions | 1 | May 12th, 2004 03:22 AM |
vlookup and multiple columns | ST | Worksheet Functions | 1 | May 6th, 2004 10:41 PM |
Splitting multiple data from 1 column to multiple columns | henry | Worksheet Functions | 0 | April 27th, 2004 05:05 PM |