Hello,

I am trying to tally the fields in several sheets of the same workbook. I
can use either hidden fields or link one cell to a hidden sheet with several
lookups, but would really like to put it all in one cell. I've put an example
below of what I would like to do. Is there an easy way to go about this? I'd
like to tally the cells of 7 sheets manytimes over.

Thank you

=(VLOOKUP(C4, '2-2'!$C$4:$J$25, 5, FALSE)+(VLOOKUP(C4, '2-3'!$C$4:$J$25, 5,
FALSE)+(VLOOKUP(C4, '2-4'!$C$4:$J$25, 5, FALSE)+(VLOOKUP(C4,
'2-5'!$C$4:$J$25, 5, FALSE)+(VLOOKUP(C4, '2-6'!$C$4:$J$25, 5,
FALSE)+(VLOOKUP(C4, '2-7'!$C$4:$J$25, 5, FALSE)+(VLOOKUP(C4,
'2-8'!$C$4:$J$25, 5, FALSE))