View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
se7098 se7098 is offline
external usenet poster
 
Posts: 79
Default lookup across multiple sheets & return sum of cells

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.