1

I want to count how many times in a column certain words from a predefined set appear. In this example those specific words will be days of the week. For example:

     Mon        =3
     Tues 
     Sun
     blank
     blank

The column has five entries, three of which are the ones I want to count.

Does anyone know the formula for achieving this in Google Spreadsheets?

0

1 Answer 1

2

ASSUMING
the weekdays will always be abbreviated exactly as shown,
are the entire cell content (not part of a longer string) and
data is in ColumnA,

the following may serve:

=ArrayFormula(sum(countif(A:A,{"Mon","Tues","Wed","Sun"})))  

with the insertion of other search strings to suit.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.