Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default obtaining formulas and help w formula

I would like to make a monthly total derived from a sum column on 4 different
worksheets.........does anyone know the formula?
Also, does anyone know where I can get a list of formula's available for use
in Excel?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default obtaining formulas and help w formula

sum each worksheet in the same cell of each worksheet and then use
=sum(firstsheet:lastsheet!yourcell)
Have you looked in HELP
--
Don Guillett
SalesAid Software

"marysea" wrote in message
...
I would like to make a monthly total derived from a sum column on 4
different
worksheets.........does anyone know the formula?
Also, does anyone know where I can get a list of formula's available for
use
in Excel?


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
Obtaining a positive variance % Bartman0609 Excel Discussion (Misc queries) 3 June 20th 06 04:38 PM
Obtaining & using last cell in a column in a cell formula mikeburg Excel Discussion (Misc queries) 4 May 26th 06 10:20 PM
Not obtaining the correct result ZT Excel Discussion (Misc queries) 1 May 3rd 06 07:19 PM
Obtaining sum for multiple criteria Teri Excel Discussion (Misc queries) 4 November 23rd 05 11:06 PM
Obtaining Max and Min Values with Sumproduct Timmy Mac1 Excel Discussion (Misc queries) 2 October 20th 05 05:33 PM


All times are GMT +1. The time now is 01:28 AM.

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

About Us

"It's about Microsoft Excel"