Count formula help?
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
|