software

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 - www.officehelp.inWith 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,quot;mm/yyquot;)=TEXT(F1,quot;mm/yyquot;))*(E2:E100=F2)*D2100)
--
HTH,

RD

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

quot;Htoomuchquot; gt; wrote in message
...
gt;
gt; Need formula to figure amount of sales per person in a given month.
gt; columns currently a
gt; Inv#, Date, Sale, Net $, Salesman #
gt;
gt; Need formula for monthly sales per Salesman #
gt;
gt; Thank you!
gt;
gt;
gt; --
gt; Htoomuch
gt; Posted from - www.officehelp.in
gt;