Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to condense my formula summing many values over many sheets
I'm having trouble finding a way to condense my formula which searches up to
40 sheets for an entry in the first column of that sheet (if it exists), which matches a value in column A on Sheet1, and then returns the value in column 6 of that sheet. An extract of my formula (which works fine) is below: =IF(ISERROR(MATCH($A1,Sheet2!$A:$A,0)),0,VLOOKUP($ A1,Sheet2!$A:$IV,6,FALSE))+IF(ISERROR(MATCH($A1,Sh eet3!$A:$A,0)),0,VLOOKUP($A1,Sheet3!$A:$IV,6,FALSE ))+ ..... My problem is that after about twelve ...+IF(... functions I run out of space in the formula bar to keep entering them. Does anyone know of a way to condense or contract these IF functions so my formula is much shorter? Any help would be greatly appreciated. Thanks, Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing values in one row based on values in another row | Excel Worksheet Functions | |||
SUM formula - using variable values | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula for Returning values in another spreadsheet | Excel Worksheet Functions |