On my analysis tab, how do I change this formula to countif - so I can see the number of participants per age per fruit.
=IFERROR(AVERAGEIFS(Data!$G:$G,Data!$B:$B,">="&$K25,Data!$B:$B,"<="&$L25,Data!$D:$D,E$23
For cell F25
And then for the overall formula, same how do I change to a countif
=IFERROR(AVERAGEIFS(Data!$G:$G,Data!$B:$B,">="&$K$25,Data!B:B,"<="&$L$25),"")
Bookmarks