?Give text value then total

[excelR8]

I have text in cells indicating the days that trainees want to take classes, i.e. SAT or M-TH. How would I calculate the number of trainees that wish to take SAT classes, and those that wish to take M-TH classes?

I tried IF, but, provided that's correct, I'm evidently not putting the formula together correctly.

 

[dave3009]

Have you considered SUMPRODUCT for this?


Dave

 

[NBVC]

Perhaps, you can use a Countif()

e.g.
=Countif(A1:A5,"SAT") where A1:A5 contain the days

 

[excelR8]

Thanks! COUNTIF was the solution!