Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM of INDEX lookups
Here is my syntax for summing looked up fields. What it is doing is looking
up all downtime minutes in the Header sheet for shift 1. But I get #REF as the answer. Can someone please help? A57 hold 1 for the shift number, B1:B700 holds the shift number in the data and A:FS is the enitre data set. =SUM(INDEX(Header!A:FS,MATCH(A57,Header!B1:B700,0) )) -- ----- Thank you, Liz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index / Hlookup | Excel Worksheet Functions | |||
Formatting result of Index function | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Min formula not returning value from Index | Excel Worksheet Functions | |||
index to a range of cells | Excel Worksheet Functions |