I'm under deadline and need some help! My spreadsheet is:
Column A = Date
Column B = Month # (such as 1 for January)
Column E = Expense $ Amount
Column F = Revenue $ Amount
Column G = Balance $ Amount

I need a formula that total columns E & F driven by a YEAR TO DATE date
(i.e. 4/30/06 to include all rows from January 1 to April 30). In cell C6 I
have the current month # (1 for Jan) & to my calculation is : SUMIF
(B10:B999,C6,E10:E999)-SUMIF(B10:B999,C6,F14:F999). This only gives me the
result for that particular month number I have in cell C6. Is there a way I
can get a YEAR TO DATE date in cell C6 to use in my formula?

My goal is to let this formula calculate a year to date balance without
having to change the formula parameters each month.

I'll take any and all suggestions! Thank you!
-
angela