View Single Post
  #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