LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Fawn
 
Posts: n/a
Default sum difference cells on multiple sheets

I have 12 worksheets with total month revenue on each one, however the
salespeople is not always in the same order. I was using the formula
sum(start:endb1) etc but this does not always work because of the order they
are ranked for each month.

Is there an easy and simple way to recap all 12 sheets without defining a
name range for each sheet.

Any suggestions would help

Thanks

Fawn


 
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
how do i add the same text after current text in multiple cells Sue Excel Discussion (Misc queries) 3 January 13th 05 09:28 PM
editing multiple sheets at once blamires Excel Discussion (Misc queries) 1 January 5th 05 08:51 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 11:15 AM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
background formatting across multiple cells Casper Excel Discussion (Misc queries) 0 November 26th 04 11:18 AM


All times are GMT +1. The time now is 02:29 PM.

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"