mtd and ytd and charting each

[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

[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?

[teylyn]

in A2 I have the days of the week Monday, Tuesday, . .

Somehow, I don't think you have all that in one cell A2.

Instead of wordy descriptions of each row and column, post a workbook with sample data and explain in context.

[cmgb802]

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.

[cmgb802]

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

[Cheeky Charlie]

http://www.excelforum.com/excel-gene...ml#post2307139

Please don't duplicate post.

[shg]

Threads merged. cmgb802, please take a few minutes to read the forum rules before posting again.

[cmgb802]

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

[shg]

See Teylin's suggestion in Post #3.

[Cheeky Charlie]

Teylyn has already asked, the description is very difficult without an example. The ideal example includes what you have and what you would like to see clearly labelled...

I'm confident we will be able to help from there.

CC

PS today, I mostly filled threads with posts that shg has to clear up.

[cmgb802]

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

[pike]

hi cmgb802,
is this what you require?
=if(k2=0,0,if(I2>0,.05-K2,"L2"))

[shg]

Threads merged, AGAIN.

cmbg, your tenure among us will be short if you don't take time to read and follow the forum rules.

[teylyn]

cmg,

take a deep breath, step back and explain again.

Mock up the expected results in the sample file, and make sure you specify the correct cells. Your original narrative seems to have several errors, i.e.

in A2 I have the days of the week Monday, Tuesday

In A2 you have only one weekday, not several, as your description suggests.

in B2 I have the dates 5/4/2010

In B2 you have only one date, not several. The dates are in colum B not in cell B2.

In C2 I have a number I enter daily and in C3 is the variance i.e =sum(c2-.40) -

You have manually entered numbers in column C. In C2 you have a manually entered number. In C3 you also have a manually entered number. There is no formula =sum(c2-.40) in C3. You have formulas in column D, but not the one you describe for C3.

Please get an understanding of your workbook and then post a description of it.

After that, explain what results you would like to see in which cells and explain the logic that would lead to those results.

If we have to second-guess your descriptions and do a Sherlock Holmes on your actual spreadsheet to find out what you really mean and really want, it does not speed up the process of finding a solution. You want help here. Help us help you!

thanks.