Surely there must be an easier way? Perhaps by using more than one
formula?

My first attempt at solving the issue was to do this:

=SUM(LOOKUP(1001,'May 2005'!B5:B53,'May 2005'!E5:E53),LOOKUP(1001,'June
2005'!B5:B53,'June 2005'!E5:E53), ...etc )

where 1001 is the employee number, May 2005 is the sheet name, B column
is where the employee number is stored and E column is where the dollar
values are stored.

When it couldn't find 1001 in the first sheet (because 1001 did not
place any orders in May), it gave an -#NA-. It's important that I list
every single employee in the final totals sheet, even if the solution
to my problem doesnt involve calculating how much every single employee
spent each and every month.


--
anieuwoudt
------------------------------------------------------------------------
anieuwoudt's Profile: http://www.excelforum.com/member.php...o&userid=24147
View this thread: http://www.excelforum.com/showthread...hreadid=377647