Hi,
I have yearly summary sheet with 12 cells, each holding the score for one month. Now I need to calculate the 3 months rolling score for the LATEST 3 months of which I have scores. Now, since I am constantly updating this form, and add the scores for new months, the 3 months rolling formula needs to be manually adjusted as well. Is there any way to let excel ignore cells in a range with "0" as a value, and instead only calculate the average of the latest 3 cells with value >0 ?
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 3MR (Mar to May)
10 20 30 10 20 0 0 0 0 0 0 0 20
Hope this makes it clear.
Thanks,
A2k
Bookmarks