XL is not too strong with 3D functions.

You'll have to start off by creating a list of your sheet names.
Needless to say, this list must match *exactly* the names on the sheet tabs.
Say A1 to A31.

Then try this:

=SUMPRODUCT(SUMIF(INDIRECT("'"&A1:A31&"'!C5"),"Ale x",INDIRECT("'"&A1:A31&"'!
C6")))

You could assign a name to the sheet range (A1 to A31), say "Days",
And also assign a cell to contain the name of the employee, say B1.

Then, it would look like this:

=SUMPRODUCT(SUMIF(INDIRECT("'"&days&"'!C5"),B1,IND IRECT("'"&days&"'!C6")))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Gymclass14 via OfficeKB.com" <u26166@uwe wrote in message
news:66ba6f2ae625b@uwe...
I need to create a Employee specific worksheet. The information I need is
based off of a daily production worsheet. I can not figure out a formula to
use. I need to have a total if the employees name is entered. This would
have to be the result across 30 other worksheets. I tried this one, with no
luck: =SUM((Day1:Day31!C5="Alex")*(Day1:Day31!C6)). Hopefully this givs the
idea of what I am trying to do. Please help!! This is driving me
crazy!!!!!!
!!!!

--
Message posted via http://www.officekb.com