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
Bookmarks