Prev: Embedded lookupNext: Two Condition - search From: Rock on 24 May 2010 14:42 I am using this formula to count the number of rows in Column C with text. =SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500))) I need, instead, for this formula to count the number of rows in Column C with specific text i.e. the text “PUSH”. Can you help? From: Dave Peterson on 24 May 2010 15:02 =countif(c:c,"push") will count the number of cells in column C that have push in them. Rock wrote:> > I am using this formula to count the number of rows in Column C with text. > > =SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500))) > > I need, instead, for this formula to count the number of rows in Column C > with specific text i.e. the text “PUSH”. Can you help? -- Dave Peterson From: Rock on 24 May 2010 15:46 This is absolutely perfect! Thank you. "Dave Peterson" wrote: > =countif(c:c,"push") > will count the number of cells in column C that have push in them. > > > Rock wrote: > > > > I am using this formula to count the number of rows in Column C with text. > > > > =SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500))) > > > > I need, instead, for this formula to count the number of rows in Column C > > with specific text i.e. the text â€œPUSHâ€. Can you help? > > -- > > Dave Peterson > . >  |  Pages: 1 Prev: Embedded lookupNext: Two Condition - search