Picking Month to date figure

[callsidd]

Hi,

Can anyone tell how to calculate current month data based on following table

I need to display MTD figure for the month of July and when September comes up and I paste data then it automatically show September data in MTD column

Excel 2010
	A	B	C
1	Sales Man	MTD	YTD
2	A
3	B
4	C
Sheet1

 

[Joe4]

How about posting what the data you are pulling from looks like and the current formulas?
Without that, we really cannot do much for you.

 

[callsidd]

Thanks for your response.

This is the date on which I need to work. Problem is the data will be added on every month and need to show MTD figure in above table that shown earlier

Excel 2010
	B	C
2	Dates	Name
3	1-Jan-14	Jacob
4	1-Jan-14	Brian
5	10-Mar-15	Daria
6	8-Jan-14	Darla
7	9-Jan-14	Darla
8	10-Jan-14	Darla
9	11-Jan-14	Darla
10	12-Jan-14	Darla
11	13-Jan-14	Darla
12	14-Jan-14	Darla
13	15-Jan-14	Darla
14	16-Jan-14	Darla
15	17-Jan-14	Darla
data

How about posting what the data you are pulling from looks like and the current formulas?
Without that, we really cannot do much for you.

 

[Joe4]

Are you simply trying to count how many times each person shows up?

I would probably consider looking at Pivot tables to do this. Here are a few pertinent links I found.
How to Create Month to Date (MTD) Comparisons with a Pivot Table + Video - Excel Campus
Create a Pivot Table YTD Totals View for Your Excel Report - dummies

 

[callsidd]

Thanks for your help Much appreciated

Are you simply trying to count how many times each person shows up?

I would probably consider looking at Pivot tables to do this. Here are a few pertinent links I found.
How to Create Month to Date (MTD) Comparisons with a Pivot Table + Video - Excel Campus
Create a Pivot Table YTD Totals View for Your Excel Report - dummies

 

[Joe4]

You are welcome!