I have the following columns: Job Title, Week, Total People

The data looks like this:

Job Title Week Total People
PM W2 1
Tech Edit W3 5
Net Engineer W2 2
Programmer W12 10
Programmer2 W1 5
PMLVL2 W3 4
.....

I have a named range of week, W1, W2, W3, W4, W5, W6, W6, W8, W8, W10,
W11, W12, named "weeks".

I'm trying to build a chart to show the total number of people for
each week. So I need to total up all the W1s, W2s, etc. to display my
chart.

So you just want to sum them?

=SUMIF(B2:B20,"W1",C2:C20)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"cs_in_va" <admin@pluginforsuccess.com> wrote in message
news:8bdcfa00-a7a4-42ac-aa52-c00fa0d2f491@a70g2000hsh.googlegroups.com...
>I have the following columns: Job Title, Week, Total People
>
> The data looks like this:
>
> Job Title Week Total People
> PM W2 1
> Tech Edit W3 5
> Net Engineer W2 2
> Programmer W12 10
> Programmer2 W1 5
> PMLVL2 W3 4
> ....
>
> I have a named range of week, W1, W2, W3, W4, W5, W6, W6, W8, W8, W10,
> W11, W12, named "weeks".
>
> I'm trying to build a chart to show the total number of people for
> each week. So I need to total up all the W1s, W2s, etc. to display my
> chart.
>
>
>
>

Have you thought about creating a pivottable and then a chart from that?

You may want to change your week abbreviations to W01, W02, ...
so that they sort in a nicer order.

cs_in_va wrote:
>
> I have the following columns: Job Title, Week, Total People
>
> The data looks like this:
>
> Job Title Week Total People
> PM W2 1
> Tech Edit W3 5
> Net Engineer W2 2
> Programmer W12 10
> Programmer2 W1 5
> PMLVL2 W3 4
> ....
>
> I have a named range of week, W1, W2, W3, W4, W5, W6, W6, W8, W8, W10,
> W11, W12, named "weeks".
>
> I'm trying to build a chart to show the total number of people for
> each week. So I need to total up all the W1s, W2s, etc. to display my
> chart.

--

Dave Peterson