=COUNTIF(B:C,"NEW*")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Richhall" wrote:

Hi

I have a named range, called Servers (B2:I50). Within this range I
want to count how many entries begin with New, so figure I need to use
Left somehow, but am not sure how I can use this in a single cell with
some countif/sumproduct function to count them all. Can anyone help
please?



B C

New1 Server C
Server A new3
Server B Server E
Server C Server F
New2 Server G
Server B Server D
Server A New 4


So this would return 4.


Cheers

Rich
.