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