How do I do a summation with text instead of numbers?

L

Lauren

I'm trying to do a summation of an attendance sheet. I have an "x" marked
for the fact that they were there, but I don't know how to format that into a
number so I can do a sum and show that they were there this many times. Any
thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMMATION combined with PV formula 3
Summation from a to b 3
How can perform a summation? 5
How do I remove a summation line? 2
problem with Summation 2
Totaling cells in multiple worksheets 4
Need Formula to fix error 1
HOW DO I ENTER DATA WHEN I SEEM TO BE STUCK IN A SUMMATION FORMULA 4

Top