calculation of mean/meadian/max from data in a range (from...to...) of dates (without VBA)

[Bluesilverfish]

Hello good morning

i hope somone can help me with my problem. I searched really a great amount of time, but everything I found and dried failed.... if I overlooked the solution to my problem in this forum I apologize in advance. (note: my mother tongue is german and not english, so please excuse if I can't explaine my poblem proberly)...

My Problem: I want to calculate of mean/meadian/max from data in a range (from...to...) of dates (see excelfile).
excelproblem_if-date-from-to.xls

without VBA!

thanks alot
sincerely
B.

[Vikas_Gautam]

check the solution man..
you will be glad...

click * if helped...

[Vikas_Gautam]

Did that help...?
waiting for *...

[Bluesilverfish]

Thanks alot!! It really helped, but unfortunaltely I get with my real data (the data is quit big: the file is 98MB) errormessages like for the average/mean "#DIV/0!" or "#NV!" and for the median "#ZAHL!".
So hopfully I will to find out the error...

thank you for repeating this fast.
sincerely
B.

[Bluesilverfish]

Thanks alot again!! I found the error :-) you are a life saver! thanks!