Excel Spreadsheet Experts
I want to know what percentage of the cells in a specific column have a value of 1 or greater. Blank cells must be ignored when calculating the average. Which formula would determine this for me? Many thanks.
in B1 (for example)
then copy down the column.
then at the bottom
=sum(b1:b99) / count(a1:a99)
(count ignores blank cells)
Thanks, you saved an under-educated individual about half a day's trial and error.
Originally Posted by nycphotography
Actually, 1 or greater requires the >= operator in the IF test in B1.
Sorry, I missed that the first time.