Good day to all. The bellow formula is part of my equation that does work. The missing pc is a date range in columns B19-b5017. We put an invoice date in the format of 3/13/2013. I want to have a return of information in the attached formula with dates from the month beginning on 1 and ending the last day of the month, IE 3/1/2013 - 3/31/2013. I am inclined to believe I am looking for a SUMIF AND but I can't seem to narrow this down.

Generally speaking, I am adding dollars up in 1 column (listed formula) that is for each month listed seperately in fields for the sales people.

=SUM(IF(A19:A5017="SM",E19:E5017))

Again, this formula works great. I just need the date part.

I appreciate any and all assistance.
Michael