How do I sum SOME values in a column based on values in another.

One column has various info. Depending on what is in that column, I want to
sum hour values in another.

Thanks,

Purtech

As long as you have a single criterion, you can use the sumif function:
=sumif(where_to_look_for_criterion,criterion,what_ to_add_on_match)
Ex: =sumif(a:a,"Your Name",b:b) will add the values from column B where the
corresponding entry in column A is "Your Name"

"purtech" wrote:

How do I sum SOME values in a column based on values in another.

One column has various info. Depending on what is in that column, I want to
sum hour values in another.

Thanks,

Purtech

With no specific information I can only make a general recommendation:

Check the Excel SUMIF function....It sounds like that's what you might need.

If that doesn't work for you , post back with some examples of the data and
how you want the formula to work.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"purtech" wrote:

How do I sum SOME values in a column based on values in another.

One column has various info. Depending on what is in that column, I want to
sum hour values in another.

Thanks,

Purtech