Formula to look up value and then sum related value 1

[stubnski]

Hi Guru's,

My issue is this, I have a column of values(word1, word2, word3) in column C and numerical values in column B. I want to search Column C for a text value and then sum the related value in column B. Values for column C are single words

Ex. Column B Column C
2 Word1
5 Word2
4 Word1
1 Word3

Total:
Word1 6
Word2 5
Word3 1


Thank you for any help!

 

[SkipVought]

Hi,

Check out the COUNTIF() function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bluedragon2]

=SUMPRODUCT((C1:C100="word")*(B1:B100))

faq68-4725 for how it works


[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

Sorry, you were wanting sums, not counts. Which version?

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

I missed the SUM requirement, too.

Use the SUMIF() function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[stubnski]

Thanks a ton. Sumif worked for what I needed. I knew it was something simple but couldn't remember what function to use. Thanks guys