Dear all
I cannot make an averageifs formula to work, the formula is: AVERAGEIFS(D$1:D$24,$B$1:$B$24,$B30,$A$1:$A$24,">="&$A$30,$A$1:$A$24,"<="&$A$33) as it returns the #DIV/0! error. I have just spent 2,5 hours trying to google a solution and ended up here.
Could someone please take a look at the attached file (the formula is in cells D30:D33) and give me a hand with the problem above?
Kind regards
Marek
Bookmarks