View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lauren Lauren is offline
external usenet poster
 
Posts: 31
Default How do I do a summation with text instead of numbers?

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?