Required
The ability to sum an array of values if a related cell includes a particular string. In this case the string is "Ferhat".
My attempt
ferhat
Ferhat is a man =SEARCH($D$1,A2) =NOT(ISERR(B2)) 10 =SUMIF($C$2:$D$4,C2=TRUE,$D$2:$D$4)
A man is Ferhat =SEARCH($D$1,A3) =NOT(ISERR(B3)) 15 =SUMIF($C$2:$D$4,C3=TRUE,$D$2:$D$4)
He is a man =SEARCH($D$1,A4) =NOT(ISERR(B4)) 222 =SUMIF($C$2:$D$4,C4=TRUE,$D$2:$D$4)
This produces some interesting/crazy results. NB "ferhat" sits in cell D1. Upper left is cell A1.
Here the answer I'm looking for is 25 = 10 + 15. However the criterion in my formula is dependent on only one cell. It should evaluate each entry in Column A and if "Ferhat" exists then include the corresponding value in the SUM.
Argh!
Thanks
Mark
Bookmarks