I would use the countif statement
for example
=COUNTIF(A1:A9,"=0")

will give you the amount of cells containing a number equal to or less
than 0 between the range A1 and A9, modify the range for your own
table.

Hope this helps

Chris


On Sun, 29 Feb 2004 18:50:03 +0000, "Keith (Southend)"
wrote:

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)
From this I can then determine the total hours/minutes of air frost,
as each number represents a 5 minute interval.

Keith (Southend)

********************************
'Weather Home & Abroad'
http://www.southendweather.net
********************************
COL Station for Southend-on-Sea
http://www.wunderground.com/weathers...p?ID=IESSEXSO1
********************************
Reply to: kreh'at'southendweather'dot'net
All mail scanned for virus's using Norton 2003