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

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

Just the job, many many thanks Chris.

That gave me 707 cells containing Zeros or less, which equated to 3535
minutes (707 x 5) 5 being the time interval that my WMII is set at.

divided by 60 to give hours (3535/60 = 58.91666667)
then for the decimal bit .91666667 x 60 / 100 = 0.55 minutes.

Total time 58 hours 55 minutes.

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


On Sun, 29 Feb 2004 18:59:20 +0000,
wrote:

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

Glad I could be of assistance Keith

On Sun, 29 Feb 2004 19:12:24 +0000, "Keith (Southend)"
wrote:

Just the job, many many thanks Chris.

That gave me 707 cells containing Zeros or less, which equated to 3535
minutes (707 x 5) 5 being the time interval that my WMII is set at.

divided by 60 to give hours (3535/60 = 58.91666667)
then for the decimal bit .91666667 x 60 / 100 = 0.55 minutes.

Total time 58 hours 55 minutes.

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


On Sun, 29 Feb 2004 18:59:20 +0000,
wrote:

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

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)