Displaying Formulas and Values of the Same Cells

E

estherf04

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????
 
F

Frank Kabel

Hi
try
="January 2003 has total of " &
SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2003))
 
Top