# Foo - Excel Spreadsheet Experts

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.

View Full Version : Excel Spreadsheet Experts

reich17
12-08-07, 07:51 PM
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.

nycphotography
12-08-07, 07:52 PM
in B1 (for example)
=if(a1>1,1,0)

then copy down the column.

then at the bottom
=sum(b1:b99) / count(a1:a99)

(count ignores blank cells)

reich17
12-08-07, 09:13 PM
Thanks, you saved an under-educated individual about half a day's trial and error.

in B1 (for example)
=if(a1>1,1,0)

then copy down the column.

then at the bottom
=sum(b1:b99) / count(a1:a99)

(count ignores blank cells)

nycphotography
12-09-07, 09:14 AM
Actually, 1 or greater requires the >= operator in the IF test in B1.

Sorry, I missed that the first time.