=AVERAGE(K2:K32)
I have this formula spitting out an average for coulmn K as you can see. The problem I am having is that the numbers in column K are populated by a formula basically adding two other columns together so if no data is entered the number returned is 0. This obviously throws off an average calculation for a month that is not complete, how can I make this formula only count the numbers which are greater than zero?
=AVERAGEIF(K2:K32, ">0")
Here is the example formula, which includes cells having value > 0.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With