G gbanks Registered User. Local time Today, 17:57 Joined Feb 9, 2000 Messages 161 Dec 21, 2005 #1 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...
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...
P Pieter New member Local time Today, 18:57 Joined Dec 21, 2005 Messages 5 Dec 21, 2005 #2 Counting cells with text Hi, you can use following formula: =countif(A1:F10;"*Monday*") Pieter
S shades Registered User. Local time Today, 11:57 Joined Mar 25, 2002 Messages 516 Dec 21, 2005 #3 Excellent Pieter. For those using the English version: =COUNTIF(A1:F10,"*Monday*") ________ vapir oxygen vaporizer Last edited: Feb 16, 2011
Excellent Pieter. For those using the English version: =COUNTIF(A1:F10,"*Monday*") ________ vapir oxygen vaporizer
