Help with IF function in a range

[natthecat]

I need to create a function as follows:

If in range C:1-C:20, if the text matches one of the four options below (Think, Explore, Build, Release), then add the corresponding percentage. If "Think" appears twice, then add 15%+15%.

Think	15.00%
Explore	20.00%
Build	33.00%
Release	25.00%

I tried to use the following formula, but if "think", "explore", "build", or "release" are there more than 1 time, it doesn't take that into consideration.

(IF(COUNTIF(C9:C20,"Explore"),"20%","0")+IF(COUNTIF(C9:C20,"Think"),"15%","0")+IF(COUNTIF(C9:C21,"Build"),"33%","0")+IF(COUNTIF(C9:C21,"Release"),"25%","0"))

 

[DanteAmor]

You can give examples of what you have in cells C1 to C20 and what result you expect.
Use the XL2BB tool

Upload an excel range:
XL2BB - Excel Range to BBCode

 

[steve the fish]

Do you mean:

=SUMPRODUCT(SUMIFS(B1:B4,A1:A4,C1:C20))

 

[natthecat]

I got it to work, my formula wasn't too far off. Thank you!