Linking Returns for Last "n" values in a column not including blanks

I have a formula that links returns for a rolling 3-month and rolling 6-month period when I have continuous data going down a column. However I need help adjusting the formula (or making a new one) to use the most recent 3 or 6 months when there are blanks for months. I have attached a file where I have sample data along with the formula.

Gooner2408 had a similar issue in a post earlier today which was solved. However, that was to average "n" values not including blanks in rows and the numbers were always positive (they were scores in a game). This may serve as a jumping off point to assist with my issue.

Any help would be appreciated.
Thanks,
Phillycheese

Maybe these array formulas

F30
=PRODUCT(IF($F$5:$F$25<>"",IF(ROW($F$5:$F$25)>=LARGE(IF($F$5:$F$25<>"",ROW($F$5:$F$25)),3),1+$F$5:$F$25,1),1))
Ctrl+Shift+Enter

F31
=PRODUCT(IF($F$5:$F$25<>"",IF(ROW($F$5:$F$25)>=LARGE(IF($F$5:$F$25<>"",ROW($F$5:$F$25)),6),1+$F$5:$F$25,1),1))
Ctrl+Shift+Enter

Originally Posted by Phillycheese5

Hey mlcb, this seems to do the trick!
Thanks so much for the assist!!!!!

You are welcome. Glad for helping