Calculate Moving Average Omitting Zeros and Blanks

[praggm]

Good afternoon all,

Long time viewer first time poster.

I've given my formula a shot by looking up prior examples however I am not getting the numbers I am supposed to.

I have a spreadsheet that I would like to calculate a moving average while omitting the zeros and blanks in the average calculation. .

within the spreadsheet columns are the months, and rows are potentially sample client numbers.

Does anybody have any thoughts ?

 

[NARAYANK991]

Hi ,

Your worksheet seems to be OK. Can you say which calculated value is wrong ?

See the attached file and comment.

Narayan

 

[praggm]

Hi Narayank991,

Thanks for taking a look !

If I highlight Row 3 Feb to Apr $ 106,287.33 as the average and that is correct, when i add a zero to May it changes from $ 106,287.33 to $ 121,720.50

 

[NARAYANK991]

Hi ,

The formula has been changed in the uploaded file.

Narayan

 

[deciog]

pragm

My contribution

= AVERAGEIF (A2:L2, "<> 0", A2:L2)

copy down

I have helped

Decio

 

[praggm]

Hi ,

The formula has been changed in the uploaded file.

Narayan

Thanks Narayan - that is working perfectly !!

 

[praggm]

pragm

My contribution

= AVERAGEIF (A2:L2, "<> 0", A2:L2)

copy down

I have helped

Decio

Hi Decio,

Not what I was looking for but thank you so much for your suggestion.