Averaging between 2 dates

[bresab]

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))

 

[Sajukai]

Not sure if I'm following 100%, but seems like you are trying for this maybe?

{=AVERAGE(IF((A6:A269>=B1)*(A6:A269<=B2)*(A6:A269<>""),B6:T269))}

 

[MARK858]

Are you sure that the cells are blank and not formulas returning ""?

 

[bresab]

I apologise my stupidity I shouldn't have posted thread without checking my data first

 

[MARK858]

I apologise my stupidity I shouldn't have posted thread without checking my data first

Hey, it is not stupidity we get this all the time where empty strings are described as blank cells.

Obviously if you can convert the cells to values then a straightforward Average is the most efficient option but if not then there are various formula alternatives.

You just need to tell us if you need the other options