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.