More Excel help please

So I have 2 columns, one with descriptions X, Y, Z, etc. and one with numbers, kind of like this -

X - 12

Y - 14

X - 10

Z - 9

Z - 14

X - 11

So I want to make a SUM type equation that will look at these columns and give me a total of all the numbers for all the X descriptions (33 in this case).

How do I do this? TIA.

SUMIF(range,criteria,sum_range)

I would use a 2nd collum with "if " formula that would look for all values of X and if it does = X then it takes the number value.

I always use their example in help and expand from there.

Good Luck

davidjs wrote: SUMIF(range,criteria,sum_range)

That worked! Thank you! GRM Board strikes again!

Yeah, that was exactly what I needed the other day; I just didn't have it configured properly.

Maybe we need to have an Excel board on here.

I keed I keed...

And technically it should read -

SUMIF(range, "criteria", sum_range)

Or from my example above assuming the first X is in cell A1

SUMIF(A1:A6, "X", B1:B6)