Is there an alpha SUMIF?

[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?

 

[J.E. McGimpsey]

One way:

=SUMPRODUCT((B2:H2="r")*(B$1:H$1="Thu"))