View Full Version : Counting cells


gbanks
12-21-2005, 10:55 AM
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
12-21-2005, 11:28 AM
Hi,
you can use following formula: =countif(A1:F10;"*Monday*")
Pieter

shades
12-21-2005, 01:10 PM
Excellent Pieter. For those using the English version:

=COUNTIF(A1:F10,"*Monday*")