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?

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

=COUNTIF(A:A,"x")
--
Gary''s Student - gsnu200770

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

=SUMPRODUCT(--(A1:A10="x"))

Regards,
Ryan--

--
RyGuy


"Gary''s Student" wrote:

=COUNTIF(A:A,"x")
--
Gary''s Student - gsnu200770