Hi,

I have been trying to figure out a formula in excel to calculate the average of a column but only includes cells that have value over a certain number (eg.14) as well as excluding blanks.

The formula i have so far is:

=SUM(K3:K439) / (COUNT(K3:K439) - COUNTIF(K3:K439,0))

I want to use this formula in a spreadsheet to help calculate the average time it takes to receive goods excluding times where we get them in express.

Thanks