Is there an excel function (Excel 2003) which exists that will allow me to
lookup data from multiple worksheets and then sum the reference/return?
I have worksheets set up for each month of the year and one set up for YTD.
Under the YTD worksheet, I need to lookup data from each months' worksheet
and then sum up the value retrieved from each month.
Because each months' data contains new sources, and the data is not in a
consistent order, a straight sum formula does not work.
Is there a way to use vlookup to retrieve data from multiple worksheets, and
then sum the values returned?
Should I be using a different function altogether?
--
ARM