adding up a particular character in a row
On May 9, 10:19 am, "rkalabokes" <u34051@uwe wrote:
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.
Try this:
=countif(J2:J99,"A")
change "J2:J99" to the correct range for your spreadsheet.
|