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

Hi,

It depends what you mean by 'value', this counts all populated cells

=COUNTA(A3:T3)

and this excludes dnb

=SUMPRODUCT((A3:T3<"dnb")*(A3:T3<""))

Mike



"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

=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

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