Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 03:45 PM
SKB
 
Posts: n/a
Default Calculating rolling sums

I have a year table and enter monthly amounts. I need to calculate the last
three months that have data in the cells. What formula do I use?

  #2   Report Post  
Old November 29th 04, 04:07 PM
Frank Kabel
 
Posts: n/a
Default

Hi
could you provide some more details about your data structure. e.g.
post some example rows.

--
Regards
Frank Kabel
Frankfurt, Germany

"SKB" schrieb im Newsbeitrag
...
I have a year table and enter monthly amounts. I need to calculate

the last
three months that have data in the cells. What formula do I use?


  #3   Report Post  
Old November 29th 04, 04:45 PM
SKB
 
Posts: n/a
Default

The data is in table form listing work hours and the percentage of time spent
on each catagory permonth.
jan feb mar april may jun july etc. three month total
12 month total
75 84 93 71
I have all of the months in the table, but only want to calculate the last
three months each month. So in the example above, I have data entered for the
first 4 months. I want to calculate the last 3 months and not include the
future months. I also want to calculate ytd. The raw data is
imported/manually entered.



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 FUNCTION WITH SUMS ABILITY Jamesy Excel Discussion (Misc queries) 1 January 10th 05 03:39 PM
LOOKUP FUNCTION WITH SUMS VALUES Jamesy Excel Discussion (Misc queries) 3 January 10th 05 03:03 PM
Formulas not calculating??? J Dizzle Fizzle Excel Discussion (Misc queries) 1 December 31st 04 07:47 PM
Histrogramms: Calculating average and standard deviation Jens Eichelbaum Excel Worksheet Functions 2 November 23rd 04 02:10 AM
Calculating Average Values Using Arithmetic Equations ryangruhn Excel Worksheet Functions 0 November 3rd 04 07:42 PM


All times are GMT +1. The time now is 12:24 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017