Hello all,
I am trying to use the AVERAGEIFS formula, averaging figures in column D divided by those in column C when criteria are met, ie
=AVERAGEIFS($D$8:$D$27/$C$8:$C$27,$A$8:$A$27,"Sub Total",$D$8:$D$27,">0")
However, this is not working, does anyone know how I might be able to do this?
I have attached the file. We do not have figures for a report in April or June, so I am trying to get an average for the year (and also trying to learn a bit on the side).
Many thanks
Rich
Bookmarks