I tried this and it's still giving me 0.5333 when I need it to show 5 out of
10 like this: 5/10
I appreciate your help!
"JE McGimpsey" wrote:

If there's nothing in the column other than your data:

=SUM(C:C)/COUNT(C:C)

or, since your data is 1s and 0s:

=AVERAGE(C:C)


In article ,
"KellyKulpa" wrote:

Each of my spreadheets are different. Some have 15 rows and some have 5.
Therefore, if there's 15 rows I need to caculate how many out of 15 items
were present. If there are only 5 rows on my spreadsheet I would need the
same but out of 5.