Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to make an average formula only count numbers greater than zero?

=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?

like image 770
user2208691 Avatar asked Apr 02 '13 18:04

user2208691


1 Answers

=AVERAGEIF(K2:K32, ">0")

Here is the example formula, which includes cells having value > 0.

like image 97
shahkalpesh Avatar answered Nov 01 '22 12:11

shahkalpesh