Formual with 2 Criteria using SUMIF and a date range

SUMIFSDATERANGE.xlsx

In the attached file I have included a date range in two cells J25 and J26, this is the first day of march and the last day of march.

So for Shad ("SM") the value for sales is calculated from the data in A:F when A = "SM" and B is >= J26 (start of month) and B <= J27 (end of month).
The same is done for the Dollars total.

=IFERROR(SUMIFS(D:D,A:A,"SM",B:B,">="&J25,B:B,"<="&J26),"")

=IFERROR(SUMIFS(E:E,A:A,"SM",B:B,">="&J25,B:B,"<="&J26),"")

Obviously you can change the location of the date range cells, I just chucked them in there for ease.

EDIT: Instead of referencing the date range cells you can modify the formulas and type in the date ranges yourself, I did it that way so you can simply change the range in one place and therefore update everyone's info in one go (once they have formulas set up).