Question Locked

Need Help on Excel "functions"

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have 2 columns, 1 is a text column with 3 different criteria (e.g., a, b, c) and the other a value column with numbers. What function can I use to sum only those values that correspond to a specific criterion?

Thanks for your help!

3 replies

by thumbsup2

It's not installed in normal installation, but it can be turned on. Install it, then you'll have an easy way to tell it to sum the values in the second column if the corresponding cell in the other column is equal/not equal the value you specify.

I normally install that wizard when I install office, so I can't remember off the top of my head how to add it later. Use the HELP feature of Excel and look for the Conditional Sum Wizard. It will tell you how to add it. NOTE: You'll need your original installation CD.

If you choose not to install the wizard, you can also use compound IF and SUMIF functions to do the same thing. Read the HELP on these functions and you should be able to figure it out.

by proportal

Type =SUMIF(range, criteria, [sum_range])

Where Range is the column with the labels (a,b,c) and the criteria is the thing you want to sum - eg all those with the value 'a'

The sum,range is optional but in this case you will need it to enter the range with the numbers.

so say you have lables in column A from cell 1 to 10 and values in colum B your formula would be

=sumif(A1:A10,"a",B1:B10)

check this out on the help filesi in excel as you can use logic within the criteria such as ">5" where you want to only sum items greater than 5.... go read.. :)

This discussion is closed to new replies.