Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION WITH SUMS ABILITY | Excel Discussion (Misc queries) | |||
LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Histrogramms: Calculating average and standard deviation | Excel Worksheet Functions | |||
Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions |