Average over last 120 days with blank cells

Hi...

I'm trying to calculate the average over the last 120 days. However some of the cells may be blank so do not count into the calculation.
I just can't seem to get the formula right.

Any assistance will be greatly appreciated.

For reference as I cannot share data due to non-disclosure agreements:
Date is in column A
Numbers will be in column B (will be between 1-5)

I also need it to only average the numbers if they are within the last 120 days, disregarding anything prior to that.
The spreadsheet will go back for a full year at least with multiple entries for each day. However again, not all cells will have data in column B.

Try this:

=AVERAGEIFS(B:B,B:B,"<>0",A:A,"<="&TODAY(),A:A,">="&TODAY()-120)

Hope this helps.

Pete

Use Pete's formula mine isn't working correctly.

Yay! It works. THANK YOU!!!

Glad to hear it, and thanks for marking the thread as Solved.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete