Hi!

If the dates are for *this year only* and start in January:

=SUMIF(A10:A999,"<="&C6,E10:E999)-SUMIF(A10:A999,"<="&C6,F14:F999)

If the dates may span multiple years then you'd need 2 cells to hold a start
date and an end date and it would take a different formula. Post back if
that's the case.

Biff

"angela" wrote in message
...
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