Hi
In addition to Sandy's suggestion, you could enter in E2 01/12/2007 and in
F2 01/01/2008 then use

=SUMPRODUCT((TEXT(G1:G370,"yymm")=TEXT(F2,"yymm")) *H1:H370)-
SUMPRODUCT((TEXT(G1:G370,"yymm")=TEXT(E2,"yymm"))* H1:H370)
--

Regards
Roger Govier

"DEVONA" wrote in message
...
I AM WORKING ON A SPREADSHEET TO TRACK MONTHLY SALES. I WANT TO DO AN IF
STATEMENT THAT WILL TELL ME IF SALES ARE UP OR DOWN COMAPAIRING THE LAST
MONTH TO THE PRIOR MONTH. I KNOW HOW TO DO THE IF STATEMENT. BUT WHAT I
DONT
KNOW HOW TO DO IS SET IT UP TO UPDATE EACH TIME A NEW MONTH ENDS.

FOR EXAMPLE I WANT TO COMPARE SALES FOR DEC WITH NOV WERE THEY UP OR DOWN.
NOW WHEN JANUARY ENDS I WANT TO COMPARE JANUARY WITH DECEMBER. I WOULD
LIKE
THE IF STATEMENT TO UPDATE TO TAKE THE NEW INFORMATION AND COMPARE IT WITH
THE PREVIOUS MONTH WITH OUT HAVING TO GO IN AND ADJUST THE IF STATEMENT
EACH
TIME. CAN THIS BE DONE AND IF SO HOW? I AM USING EXCEL 2003 AT THIS POINT
AND
TIME.