Counting number of "N",s

B

Bob Phillips

=COUNTIF(1:1,"N")

--

HTH

RP
(remove nothere from the email address if mailing direct)


Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren
 
D

Darren Forward

Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren
 
D

David French

=COUNTIF(range,"n")

That should work it!

Dave French
MOS XP Master Instructor
Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren
 
D

Darren Forward

Thanks for that how would you get countif NOT to count "N" the same as "N".

Many Thanks Darren
=COUNTIF(range,"n")

That should work it!

Dave French
MOS XP Master Instructor
Is there a way to count the number of "N",s in a row. How would you handle if the "N" is "n" or "N" colours.


Many thanks Darren
 
Top