Average IF formulae
Hi @Nick Korna,
I have a scenario here where I have placed a simple Avg formulae and a AvgIF formulae to calculate scenario 1
But incase if there is a Zero, or NA or something, the formulae should be able to still calculate which isnt working with the simple IF or <>0 or If error.
Can you please suggest.