Is there an alpha SUMIF?

A

Alison

I have a spreadsheet in which I am trying to count the
character "r" based on a day criteria

For example, in a month, I want to count the number of
times an "r" is entered for a Thursday.

day Thu Fri Sat Mon Tue Wed Thu
persA r r r 1 1 r
persB 1 1 r r

persA would have 2
persB would have 0

I have been able to use SUMIF to count the number of times
a 1 appears on a given day. Is there an alpha equivalent?
 
Top