Hi all
I am trying to average a range which is determined by 2 dates manually entered into cell B1(Start Date) B2(End Date)
the dates are in Column A and the Range is B6:T269)
the formula I created below works but not if any of the cells in the range are blank. I want to find the average if any cells are blank, I have tried to use Averageif "<>0" in the formula but seem to get a VALUE error. I would be grateful if someone could help me on this matter
Thanks
=AVERAGE(IF((A6:A269>=B1)*(A6:A269<=B2),B6:T269))
I am trying to average a range which is determined by 2 dates manually entered into cell B1(Start Date) B2(End Date)
the dates are in Column A and the Range is B6:T269)
the formula I created below works but not if any of the cells in the range are blank. I want to find the average if any cells are blank, I have tried to use Averageif "<>0" in the formula but seem to get a VALUE error. I would be grateful if someone could help me on this matter
Thanks
=AVERAGE(IF((A6:A269>=B1)*(A6:A269<=B2),B6:T269))
Last edited: