LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
KellyKulpa
 
Posts: n/a
Default I need a formula to calculate the ratio of #'s in a row and column

Hello. I'm using Excel 2000 and need help finding a formula to calculate the
ratio in columns and rows.

For example: I'm using 1's and 0's ( 1 if the item is present and 0 if it is
not present). So, I need a formula that will show 8/10 of the items were
present. See my example below.

Column C
1
0
1
0
1
=3 (sum)
=3/5 (ratio)

Thanks for your help!!!! Kelly
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate a percentage formula with existing data? MeaganNW Excel Worksheet Functions 4 September 8th 08 08:39 AM
Need a formula to calculate the number of months to pay off a loan kv Excel Discussion (Misc queries) 2 August 2nd 05 09:02 PM
Creat a formula to calculate working hrs according to number of da Bren Excel Worksheet Functions 2 August 1st 05 12:57 PM
How do I calculate a formula with a not-to-exceed answer? danfromthelake Excel Discussion (Misc queries) 1 January 19th 05 01:57 AM
X IN A CELL TO CALCULATE A FORMULA JUSTIN Excel Worksheet Functions 1 January 3rd 05 11:08 PM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"