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*")
________
vapir oxygen vaporizer (http://oxygenvaporizer.com)