mtd and ytd and charting each

I have several worksheets (each worksheet for different tech) and all are set up as tables;
in A2 I have the days of the week Monday, Tuesday, . . . in B2 I have the dates 5/4/2010, . . . and have the dates going through 3/31/2011.

In C2 I have a number I enter daily and in C3 is the variance i.e =sum(c2-.40) - if I do not have anything filled in for the days that have not yet occured, ie 5/16/10 I automatically get -.40. I need my C2 date to calculate for charting mtd and ytd (which I can filter) but am unsure how to go about chart.

Also I can get my mtd and ytd by filtering but was wondering how I would go about doing my mtd & ytd for each of my techs (separate worksheets) into one simple worksheet. All my worksheets have a column for tech ID and name to reference. I need to be able to chart progress individually and as a group. I hope this makes sense.

Thanks for your help

Originally Posted by cmgb802

I have several worksheets (each worksheet for different tech) and all are set up as tables;
in A2 I have the days of the week Monday, Tuesday, . . . in B2 I have the dates 5/4/2010, . . . and have the dates going through 3/31/2011.

In C2 I have a number I enter daily and in C3 is the variance i.e =sum(c2-.40) - if I do not have anything filled in for the days that have not yet occured, ie 5/16/10 I automatically get -.40. I need my C2 date to calculate for charting mtd and ytd (which I can filter) but am unsure how to go about chart.

Also I can get my mtd and ytd by filtering but was wondering how I would go about doing my mtd & ytd for each of my techs (separate worksheets) into one simple worksheet. All my worksheets have a column for tech ID and name to reference. I need to be able to chart progress individually and as a group. I hope this makes sense.

Thanks for your help

Oops also - how do I have it just showing April instead of the entire month?

Originally Posted by cmgb802
I have several worksheets (each worksheet for different tech) and all are set up as tables;
which I can filter.

How I would go about doing my mtd & ytd for each of my techs (separate worksheets) into one simple worksheet. All my worksheets have a column for tech ID and name to reference. I need to be able to chart progress individually and as a group. I hope this makes sense.

Thanks for your help
How do I have it just showing April instead of the entire month?

If no info is entered in a day of the week should I be using a =sumif calc? or countif? calc.

I have several worksheets (each worksheet for different tech) and all are set up as tables;
in A2:A366 I have the days of the week Monday, Tuesday, . . . in B2 I have the dates 5/4/2010, . . . and have the dates going through 3/31/2011.

In C2 I have a number I enter daily and in C3 is the variance i.e =sum(c2-.40) - if I do not have anything filled in for the days that have not yet occured, ie 5/16/10 I automatically get -.40. Unsure if I should be using =sumif, or count, then I need to average each column and if no info in cell would that also be an =averageif formula?

I need my C2 date to calculate for charting mtd and ytd (which I can filter) but am unsure how to go about chart.

Also I can get my mtd and ytd by filtering but was wondering how I would go about doing my mtd & ytd for each of my techs (separate worksheets) into one simple worksheet. All my worksheets have a column for tech ID and name to reference. I need to be able to chart progress individually and as a group. I hope this makes sense.

Thanks for your help

I've read forum rules and have updated my posts - can someone please point me in the right direction

Not at you, at myself, sorry if this is too much.

Here is a sample of my project
I need to have mtd, and ytd charts for each tech (i will put next to table) and a separate worksheet to compare all techs.

thank you
very new to this website and I know I've posted a lot but really could use some help on this project.

Thank you
PS -
=if(I2>0,.05-K2,"L2")
if 0.00% is in K2, how would I keep that in L2?

Thank you