I'm looking to create a program that will do the following:

Search 2 columns in an excel spreadsheet
Column 'A' - a date Column (dates are already grouped in sequentia
order)
Column 'B' - an integer Column (contains both positive and negativ
integers)

My end result should be: I need to know the total of the negativ
integers per month

For example
Column A has dates (1/1/2003, 1/5/2003, 1/15,2003, 2/1/203)
Column B has values (-10,5,-8,-15)
My result should be something like: January 2003 has total of 18

Any Suggestions????

--
Message posted from http://www.ExcelForum.com