Thanks for feeding back, Rachael.

Note that my formula will return a zero if A1 does not contain one of
the listed names. Also, the IFs themselves are not nested, so you do
not suffer from the limit.

Pete

On May 16, 9:33*am, Rachael F
wrote:
Thanks very much for all the replies. I have used Pete's formula.

Best wishes.

Rachael