#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default sum sheet

I have several sheets and one sum sheet. There are different names peoples on
the sheets on the different cells. I need all peoples on the sum sheet.
Mery,
Thanks Much
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default sum sheet

Have a look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mery" wrote in message
...
I have several sheets and one sum sheet. There are different names peoples
on
the sheets on the different cells. I need all peoples on the sum sheet.
Mery,
Thanks Much


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default sum sheet

Hello Mery! Please take a look at this:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.contextures.com/xlPivot02.html


Regards,
Ryan---

--
RyGuy


"Don Guillett" wrote:

Have a look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mery" wrote in message
...
I have several sheets and one sum sheet. There are different names peoples
on
the sheets on the different cells. I need all peoples on the sum sheet.
Mery,
Thanks Much



Reply
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 single value in one sheet, return multiple results from theother sheet Chuck[_3_] Excel Worksheet Functions 1 April 4th 08 06:17 AM
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 mistewalker Excel Worksheet Functions 5 January 6th 08 11:36 PM
create a formula in one sheet that would read data from separate sheet automatically QD Excel Discussion (Misc queries) 0 December 8th 06 04:17 AM
How do I select price from sheet.b where sheet.a part no = sheet.b Sonny Excel Worksheet Functions 4 April 4th 06 05:08 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM


All times are GMT +1. The time now is 10:46 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"