Sumifs question

Hello,
I have a sumifs that is calculating YTD, and I want this to dynamically change.

I have a simple table with 3 variables; Year, Month, and Revenue. The following code would be YTD October. Let's say B2 has the value Oct-1-2011

Current code:

Please Login or Register  to view this content.

How can I replace the "<=10" to reference the month(B2) variable?

Thanks!

=SUMIFS(<sum range>,<year variable range>,Year(B2),<month number range>,"<="&Month(B2))


Regards, TMS

You're welcome ... only easy if you know.

They say, the only hard questions are the ones you don't know the answer to.

Regards, TMS