Mike & Gary,


Both solutions worked, many thanks for the help.

Kind regards,

John

"Gary''s Student" wrote:

=COUNTA(A3:T3)
and
=COUNTA(A3:T3)-COUNTIF(A3:T3,"dnb")
--
Gary''s Student - gsnu200852


"John" wrote:

I need to count the numbers of columns from A3:T3 which have any value
entered in the cell. I also in another cell need to count the non blank cells
but ignore any cells which contain the text dnb from columns A3:T3



Thanks for any help you can provide.

John