In article ,
"Keith (Southend)" writes:
I wonder if someone can help me with a little 'excel' problem. For my
COL data I need to be able work out how many hours of Air Frost there
has been in the month. I can 'export' data from wy WMII into excel,
but then want a formula that can count the toal number of cells, in a
column, that contain numbers that are '0' or below (-0.1, -0.2.. etc)

Use the COUNTIF function. If your data is in the range B1:B100 then
=countif(B1:B100, 0.001) would do the job. (Assuming you really do
mean "0 or below". For air frost, shouldn't it be strictly below 0? If
so, replace 0.001 by 0.)
--
John Hall

"Distrust any enterprise that requires new clothes."
Henry David Thoreau (1817-1862)