Assume that your data is starts From A1 cell and end with B4 cell.

A Col B Col
Row 1 Server A New1
Row 2 New 1 New 2
Row 3 Server B new 3
Row 4 new 2 new 1

Copy the below formula and place the cursor in any cell other than A1 to B4
cell and press F2 and give Cntrl+V and Press Cntrl+Shift+Enter since it is an
array formula.
=SUM(ISNUMBER(FIND("New",A1:B10))+0)

After pressing Cntrl+Shift+Enter the formula will be covered with Curly
Braces like the below in the Formulabar.

{=SUM(ISNUMBER(FIND("New",A1:B10))+0)}

Dont type the Curly Braces Manually.

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


"Richhall" wrote:

Excellent thank you, how do I count Unique entries please? Request has
moved on a notch!

i.e

Server A New1
New 1 New 2
Server B new 3
new 2 new 1

Would return 3.

Thank you

Rich
.