#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Growth

I have a spreadsheet with tabs for Jan, Feb, March, & April with totals for
each month and I am trying to figure the growth/loss for the 1st Qtr. I have
created a new tab titled "1st Qtr Growth" and I need to enter a calculation
to look at the totals for all four months and give me the growth/loss for the
1st Qtr.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 623
Default Growth

1. A quarter contains 3 months, not 4.

2. What are you totaling? Specific cells in each sheet?

3. To try to point you in the right direction, in your "1st Qtr Growth" sheet,
you can sum your monthly sheets in the following fashion:

=Jan!a1+Feb!a1+Mar!a1

--
Regards,
Fred


"Carter68" wrote in message
...
I have a spreadsheet with tabs for Jan, Feb, March, & April with totals for
each month and I am trying to figure the growth/loss for the 1st Qtr. I have
created a new tab titled "1st Qtr Growth" and I need to enter a calculation
to look at the totals for all four months and give me the growth/loss for the
1st Qtr.



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
Growth Rate Native Excel Discussion (Misc queries) 2 September 21st 06 12:34 AM
Growth of $10,000 Rachel Excel Worksheet Functions 1 July 3rd 06 05:40 PM
Growth Tom Letcher Excel Worksheet Functions 7 October 24th 05 09:57 AM
Constant growth 050529 Excel Worksheet Functions 5 May 29th 05 08:17 PM
projecting growth eplfan Excel Worksheet Functions 1 November 5th 04 01:41 PM


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