Solved: Average Formula to Exclude blank or zero values - Page 2

HeathBiller · 03-10-2024 04:46 PM

Hi,

I am trying to average a list of Ages but want to exclude any cells that are blank or zero. Here is my current formula. average(Client[Client Age])

I have tried multiple different ways to try and exclude blank and zero values but so far have been unsuccessful. Hoping someone might have some ideas.

Thank you.

AleksiAlkio

Another way is to use SELECT() with your formula, like..
AVERAGE(SELECT(Client[Client Age],AND(ISNOTBLANK([Client Age]),[Client Age]>0)))

View solution in original post