Help monthly sales by person

[Htoomuch]

Need formula to figure amount of sales per person in a given month.
columns currently are:
Inv#, Date, Sale, Net $, Salesman #

Need formula for monthly sales per Salesman #

Thank you

 

[Ragdyer]

With your headers in Row1, from Columns A to E,
And the datalist from A2 to E100,
Enter the month and year to lookup in F1 (mm/yy),
And the salesman's # in F2,
And try this:

=SUMPRODUCT((TEXT(B2:B100,"mm/yy")=TEXT(F1,"mm/yy"))*(E2:E100=F2)*D2100)