View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] calibansfolly@gmail.com is offline
external usenet poster
 
Posts: 11
Default 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.