Choice of Formula

[Naraine Ramkirath]

I have a spreadsheet (daily sales transactions) that contains three columns.
Column A is Sales Rep; Column B is date; Column C is sales.



Data consist of data from the beginning of the year ( say Jan1 2007) thru
today.



I would like to create a summary report in the following format:



Sales Rep Month Sales YTD Sales



I know I can use the sumif to get the year to date sales. What formula can I
use to get the month to date sales as I would need from say June 1 thru June
28?



Your help is greatly appreciated.

 

[Toppers]

=Sumproduct(--(Sheet1!a2:a100=a2),--(month(Sheet1!b2:b100)=6),Sheet1!C2:c100)

Sheet1 contains your transactions

A2 is sales rep on summary

6 is month six (june)

HTH

 

[Naraine Ramkirath]

Toppers,

that works great, but can I use this instead?

SUMPRODUCT(--(Sales!$A:$A=Report!B9),--(MONTH(Sales!$F:$F)=6),Sales!$D:$D)

i don't want to have to change the range each day.

 

[Peo Sjoblom]

No, not unless you use Excel 2007, why don't you just use something that you
will never reach like A1:A25000

 

[Naraine Ramkirath]

Peo, thanks. that works.

No, not unless you use Excel 2007, why don't you just use something that you
will never reach like A1:A25000