Counting Function

James Burstall · Nov 20, 2003

I am trying to set up a formula than counts the number of
times on one row that there is a cell containing a
particular letter (s) with a blank cell to teh left of it.
I have tried all the help that I can find, but no joy. Is
there anyone out there with any bright ideas?
Thanks

Paul · Nov 20, 2003

James Burstall said:
I am trying to set up a formula than counts the number of
times on one row that there is a cell containing a
particular letter (s) with a blank cell to teh left of it.
I have tried all the help that I can find, but no joy. Is
there anyone out there with any bright ideas?
Thanks

Amswered in .misc. Please don't multi-post.

Leo Heuser · Nov 20, 2003

One way:

=SUMPRODUCT((LEN(A2

10)-LEN(SUBSTITUTE(A2

10," s","")))/2)

Count Number of Unique Cells That Don't Have Certain Characters	0	Jan 21, 2014
vlookup or some other function that counts rows	0	Oct 17, 2013
Need some help with a COUNTIF function	4	Feb 10, 2011
Counting assistance	3	Feb 10, 2011
Is there a function to count how many times a cells value is used?	0	Jan 23, 2014
SUMPRODUCT formula I think w/ wild card & number vs number as text	8	Feb 18, 2014
COUNTIFS ?	1	Mar 17, 2014
Counting dates in filtered column	1	Mar 5, 2013

Counting Function

James Burstall

Paul

Leo Heuser

Ask a Question

Similar Threads