Peo, thanks. that works.
"Peo Sjoblom" wrote in message
...
No, not unless you use Excel 2007, why don't you just use something that
you
will never reach like A1:A25000


--
Regards,

Peo Sjoblom



"Naraine Ramkirath" wrote in message
...
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.



"Toppers" wrote in message
...


=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" wrote:

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.