Thanks for your help...i downloaded the morefunc add-in, however, when i try
this inserting the names of my spreadsheets in placed of sheet1:sheet10
i am getting an error.


"Teethless mama" wrote:

=SUM(SUMIF(INDIRECT("Sheet"&{1,2,3,4,5,6,7,8,9,10} &"!A1:A100"),C1,INDIRECT("Sheet"&{1,2,3,4,5,6,7,8, 9,10}&"!B1:B100")))

or

Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/english/

...then use this formula

=SUMPRODUCT(--(THREED(Sheet1:Sheet10!A1:A100)=C1),THREED(Sheet1: Sheet10!B1:B100))



"se7098" wrote:

i have a workbook with 10 worksheets labeled with employees names.

i am attempting to create a summary sheet to capture a snapshot of the time
spent on each task.

The worksheets are basically the same with some minor task variances.

I need to lookup tasks across the multiple worksheets and return the sum for
each task.

i.e., lookup "creating and posting requisitions" on every worksheet and
return the sum of all employees performing that task

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions