Sumif with date range and other criteria

[AlanaT]

How do I write a formula that is IF and SUMIF?
I have raw data (in Sheet2) of Column A=Invoice Date, Column B=Sales Rep Name, and Column C= Sales Amount.
What I need to do is sum each Sales Reps' Sales Amount for each date range (i.e: May 1st to May 7th).
I'm using Named Ranges for the start and end date of each week.
Tried something like this:
=SUMIFS(Sheet2!$C:$C,Sheet2!$A:$A,">=Week1Start",Sheet2!$A:$A,"<=Week1End",Sheet2!$B:$B,$A1)
{where column A lists all rep names}

Help!?

 

[Fluff]

How about

=SUMIFS(Sheet2!$C:$C,Sheet2!$A:$A,">="&Week1Start,Sheet2!$A:$A,"<="&Week1End,Sheet2!$B:$B,$A1)

 

[AlanaT]

Awesome! I guess it was a syntax error?
Thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.