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

Need formula for monthly sales per Salesman #

Thank you!


--
Htoomuch
Posted from - http://www.officehelp.in

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)*D2:D100)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Htoomuch" wrote in message
...

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

Need formula for monthly sales per Salesman #

Thank you!


--
Htoomuch
Posted from - http://www.officehelp.in