Looks like you will have to use a macro...

What is in A3?
Do you have any experience with macros?

--
Always provide your feedback...


"se7098" wrote:

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

i am creating a summary sheet that i want to return the sum of each function
performed by the employee into a single cell.

i.e., lookup contents of cell a3 on all worksheets and return sum of cell b3
for all employees/worksheets.

is this possible? thanks.