Greetings,

I have a dataset of year/month/rainfall data that I am doing some
simple statistics (average, std dev, etc.) upon. I have what I hope is
a simple question. How can I scan column B (month), match a certain
month, and do a certain stastic upon all of the rainfall for that
month....for example:

1970 01 1.35
1970 02 3.45
1970 03 5.33
1971 01 0.99
1971 02 4.30
1971 03 5.12
1972 01 0.21
1972 02 2.22
1972 03 7.08

I want one cell to give the average rainfall for March, or the Std Dev
for March, etc. I would like to set up a template of forumulas so that
I can just drop any data (each state county) and have teh statistics at
the top. So, I assume a B:B will be involved to handle varying data
lengths (or at least a b10:b1000, for a buffer).

I looked at SUM_PRODUCT, but it doesn't really do what I need, plus I
am doing more than just a sum.

Any ideas before I start writing a perl script to do this? :)

Thanks,
Brad


--
illston
------------------------------------------------------------------------
illston's Profile: http://www.excelforum.com/member.php...o&userid=23771
View this thread: http://www.excelforum.com/showthread...hreadid=374152