| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF accross multiple columns
I am trying to Sum a Year to date range based on a month reference. Ideas?
Sheet 1: Jan05 Feb05 Mar05 12345 12 34 56 67890 78 90 12 23456 34 56 78 Sheet 2: Column 1 Column2 12345 =SUMIF(CustNum,CustNum2,INDIRECT(Month)) Column3 (Not working) =SUMIF(CustNum,CustNum2,INDIRECT(CONCATENATE(Month ,"Total"))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
| SUMIF and MULTIPLE DATA | Excel Discussion (Misc queries) | |||
| Connect multiple columns in 1 row to another? | New Users to Excel | |||
| Sumif over multiple columns | Excel Worksheet Functions | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Threaded Mode
