=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.