Try...

=SUMPRODUCT(--($A$2:$A$10=DATE(2005,4,1)),--($A$2:$A$10<=DATE(2005,4,30)
),--($B$2:$B$10="John Smith"),$C$2:$C$10)

OR

=SUMPRODUCT(--($A$2:$A$10=D1),--($A$2:$A$10<=E1),--($B$2:$B$10=F1),$C$2:
$C$10)

....where D1 contains the start date, E1 contains our end date, and F1
contains the salesperson of interest. Adjust the ranges accordingly.

Hope this helps!

In article ,
brodiemac wrote:

Here's the senario. Column A has dates of sales. Column B has the sales
person's name. Column C has the amount of the sale. What I am looking for
is a sumif statement that will total the sales in column C by salesperson in
between specific dates. So for example, I want all the sales for John Smith
totaled between the dates of 4/1/05 and 4/30/05. I've tried a bunch of
different things but have had no luck getting this to work. Any help is
appreciated.