SUM(If a cell contains a certain word, then return the value of that cell (another cell))

[gjrr4x1]

I did a search and could not find the solution, so there it goes:

I have a table with nine funds (c4:c12) and a style for each fund (D4:D12), I want a formula in C17 that will sum the weight of each fund (b4:b12) if d4=Balanced, d5=Balanced, d6=Balanced and so on.

Can I do this? I tried with =SUM(IF(D4:D12=''Balanced'';B4:B12;'''') but it gave back an error.

Can you help me?

[Kevin UK]

Hi gjrr4x1

Try the following in C17 and copy down.

Please Login or Register  to view this content.

[Moo the Dog]

You can try this:

=SUMIF($D$4:$D$12;"Balanced";$B$4:$B$12)

- Moo

* Kevin UK beat me to it.
Looks like you use semi-colons as argument separators, so I changed the commas to semi-colons above

[Norie]

Try this in C17 and copy down.

Please Login or Register  to view this content.

[ConneXionLost]

Since you're using semicolons instead of commas:

Please Login or Register  to view this content.

[gjrr4x1]

Wow, thanks for the quick response Kevin!

That formula worked perfectly, can't believe it took me half an hour to get nothing and you solved the problem in a matter of seconds. Impressive!

Thankyou very much for your help!
Have a nice evening.

[gjrr4x1]

Thanks to ConneXionLost, Norie, and Moo the Dog as well! I really envy your MS Excel skills, thanks for the help!