software

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,quot;Your Namequot;,b:b) will add the values from column B where the
corresponding entry in column A is quot;Your Namequot;

quot;purtechquot; wrote:

gt; How do I sum SOME values in a column based on values in another.
gt;
gt; One column has various info. Depending on what is in that column, I want to
gt; sum hour values in another.
gt;
gt; Thanks,
gt;
gt; 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-Proquot;purtechquot; wrote:

gt; How do I sum SOME values in a column based on values in another.
gt;
gt; One column has various info. Depending on what is in that column, I want to
gt; sum hour values in another.
gt;
gt; Thanks,
gt;
gt; Purtech