Hi,
Please can you help with this?
I need a formula that will work out an average value from a range of values which contain some blanks.
For example:
1 2 3 4 5 6
5 0 - 1 - 8
Row A contains weeks 1-6 (where week 1 is the most recent week and week 6 is the least recent week), row B contain a range of values for each of those weeks. I need a formula that will work out the average value for the three most recent weeks where there is a value present.
For example, the average value for the most recent 3 weeks with a value in row B is 2 (the sum of 5 plus 0 plus 1 (the formula should disregard the cell in the third column where there is no value present) divided by 3 = 2).
Please can anybody advise of a formula that will do this for me?
Thanks for your help.
Bookmarks