Counting cells (1 Viewer)

[gbanks]

Don't know if this is possible but I would like to count the number of cells in a spread sheet based on the text in the cell. I would like to count the number of fields with the word Monday in them. Is this possiible? Thanks...

 

[Pieter]

Counting cells with text

Hi,
you can use following formula: =countif(A1:F10;"*Monday*")
Pieter

 

[shades]

Excellent Pieter. For those using the English version:

=COUNTIF(A1:F10,"*Monday*")
________
vapir oxygen vaporizer