Last 5 week average, nonzero

**vermont1972** · 07-18-2009, 03:07 PM

Hello!

I am hoping someone can help.

I am working on a very large tool, and one of the metrics I would like to "automate" is the LAST 5-week average.

Currently, In column "BT", I have the sell thru % for each actualized fiscal week (have actualized values through week 23, leaving 24-52 blank). What I want is to find the LAST 5-weeks with non blank values and average them without having to manually change the cell reference every week. Is this possible? I have searched in this forum, but have been unable to find a solution. Help?

Thank you so much!

**contaminated** · 07-18-2009, 03:51 PM

Like this?

**vermont1972** · 07-18-2009, 04:36 PM

It worked!!! Thank you SOOOO much!

**contaminated** · 07-18-2009, 05:18 PM

If it solves your issue, mark the thread as "SOLVED", and don't forget do add reputation...

**ejthomas** · 03-21-2014, 11:53 AM

Hi,

I have a similar issue, but my data is vertical instead of horizontal. I need to find the five week average, but the formula changes whenever I add in an additional week. I just need the first five rows. Any advice? I've tried the $ trick around the rows that I want to stay the same, but no luck.