If all of your "data" is TEXT and/or numbers below 30000, then this might do
it for you..........

=COUNTIF(A3:F3,"30000")

Vaya con Dios,
Chuck, CABGx3



"mango7" wrote:


I want to create a column which will give me a total of the number of
columns which contain a date. Therefore count the columns not the data
in the cells. Any ideas?


--
mango7
------------------------------------------------------------------------
mango7's Profile: http://www.excelforum.com/member.php...o&userid=29529
View this thread: http://www.excelforum.com/showthread...hreadid=492293