=sumproduct(--(a1:a10="john"),--isnumber(b1:b10))

Roger wrote:

If in range A1 to A10 there were a list of different peoples names - "John"
"Dave" etc
How do I count the number of numeric entries in range B1 to B10 for say
"John" only

I can do it with DCount and set the criteria accordingly but is there
another way please

Thankyou in anticipation

--

Dave Peterson