Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying BOTH formulas and values | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Referencing another WB's cells, but not formulas/values. | Excel Worksheet Functions | |||
Displaying temporary values on formula cells. Is this possible?q | Excel Discussion (Misc queries) | |||
How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) |