Displaying Formulas and Values of the Same Cells
 

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

Displaying Formulas and Values of the Same Cells
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"estherf04 " schrieb im
Newsbeitrag ...
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 sequential
order)
Column 'B' - an integer Column (contains both positive and negative
integers)

My end result should be: I need to know the total of the negative
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/