LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP TO RETURN MULTIPLE VALUES wilma2299 Excel Discussion (Misc queries) 1 August 18th 07 01:38 PM
Lookup and Return Multiple Values billinr Excel Worksheet Functions 3 April 27th 07 06:59 PM
Lookup in Multiple Columns, Return Multiple Values andy62 Excel Worksheet Functions 3 July 6th 06 02:36 AM
how to lookup a value and return multiple corresponding values Asthee Excel Worksheet Functions 1 November 5th 05 01:49 PM
Lookup with multiple value return Mike Quinn, SrA, USAF Excel Worksheet Functions 2 February 15th 05 05:15 PM


All times are GMT +1. The time now is 12:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"