Vlookup

Tommy · Oct 18, 2004

I am trying to setup a vlookup to go into mulltiple worksheets which have
similar data and having that total into one sum?

David McRitchie · Oct 18, 2004

I think you want 3D Sum
Look for 3-D in your HELP.

i.e. to total inclusive cells in Sheet1:Sheet10
=SUM('sheet1:sheet10'!D4
=---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm