adding up a particular character in a row

R

rkalabokes

I have an attendance list and I need to have my final column telling me every
time the letter "A" (for absent) hits on that row.
 
C

calibansfolly

I have an attendance list and I need to have my final column telling me every
time the letter "A" (for absent) hits on that row.
Click to expand...

Try this:

=countif(J2:J99,"A")

change "J2:J99" to the correct range for your spreadsheet.
 
R

rkalabokes

that (of course) did end up working. thank you very much! it was much
appreciated
 
Top