Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to calculate a percentage formula with existing data? | Excel Worksheet Functions | |||
Need a formula to calculate the number of months to pay off a loan | Excel Discussion (Misc queries) | |||
Creat a formula to calculate working hrs according to number of da | Excel Worksheet Functions | |||
How do I calculate a formula with a not-to-exceed answer? | Excel Discussion (Misc queries) | |||
X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions |