|
Excel help :-)
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 |
Excel help :-)
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 |
Excel help :-)
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) |
Excel help :-)
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 |
| All times are GMT. The time now is 01:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2006 WeatherBanter.co.uk