Selective cell skipping in formula

Please take a look at the following formula: =((AVERAGE(AQ4:AQ335)-AVERAGE(AO4:AO335))/STDEV.P(AQ4:AQ335,AO4:AO335))*SQRT(252)

This formula is calculating excess return of an equity (AQ4:AQ335) to a benchmark (AO4:AO335). The problem is that there a blank dates in the AQ array and no blanks in the AO array, so I'm not getting an accurate result. Is there any way to only include values in AO array where there are corresponding values in AQ? In other words, can the formula not include blank those rows within both or only AO columns where there is a blank value in AQ?

Thank you!

Best bet is probably to make a copy of the data elsewhere and just manipulate the rows to exclude data that isn't available for both dates.

Thanks for your reply. My workaround right now is to use this formula in another column: =IF(ISNUMBER(AO66),AM66,""), which outputs a blank when there is a blank AO. It would be awesome however to not have to do this for 60 sheets! I appreciate all help.