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.

This site is temporarily in read-only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .