Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kestle
 
Posts: n/a
Default write a formula to sum cells on different pages of the same workb.

I am trying to create a formula that will sum target cells on different pages
and total them on a final tally sheet. How do i do this?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
use a formula such as
=SUM('sheet1:sheet10'!A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Kestle" schrieb im Newsbeitrag
...
I am trying to create a formula that will sum target cells on

different pages
and total them on a final tally sheet. How do i do this?


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
Formula to count the cells in a range that have a fill color. Molly F Excel Discussion (Misc queries) 2 January 19th 05 06:15 PM
How do i select different cells to be use in a formula. Manuel Excel Discussion (Misc queries) 1 January 13th 05 03:52 PM
how do I create a formula to seperate name into two cells (last, . jobby55 Excel Discussion (Misc queries) 2 January 13th 05 05:00 AM
Using color to ignore cells in a formula????? Mike A. Excel Discussion (Misc queries) 2 December 8th 04 05:35 PM
A formula to check differrent cells Carlsbad Excel Worksheet Functions 0 October 28th 04 01:19 AM


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