Is there an alpha SUMIF?

  • Thread starter Thread starter Alison
  • Start date Start date
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?
 
Back
Top