=COUNTIF(B2:I50,"new*")

note the * after new
Greetings from New Zealand

"Richhall" wrote in message
...
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