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!


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

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

RD

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

"Htoomuch" <[email protected]> wrote in message
news:[email protected]...
>
> 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!
>
>
> --
> Htoomuch
> Posted from - http://www.officehelp.in
>