Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

Foo Off-Topic chit chat with no general subject.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 12-08-07, 07:51 PM   #1
reich17
Thread Starter
 
reich17's Avatar
 
Join Date: Jan 2005
Bikes:
Posts: 414
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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.
reich17 is offline   Reply With Quote
Old 12-08-07, 07:52 PM   #2
nycphotography
NYC
 
nycphotography's Avatar
 
Join Date: Sep 2006
Bikes:
Posts: 2,138
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 107 Post(s)
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 is offline   Reply With Quote
Old 12-08-07, 09:13 PM   #3
reich17
Thread Starter
 
reich17's Avatar
 
Join Date: Jan 2005
Bikes:
Posts: 414
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Thanks, you saved an under-educated individual about half a day's trial and error.

Quote:
Originally Posted by nycphotography View Post
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 is offline   Reply With Quote
Old 12-09-07, 09:14 AM   #4
nycphotography
NYC
 
nycphotography's Avatar
 
Join Date: Sep 2006
Bikes:
Posts: 2,138
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 107 Post(s)
Actually, 1 or greater requires the >= operator in the IF test in B1.

Sorry, I missed that the first time.
nycphotography is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 07:05 PM.