Sum specific word in area

[szakharov7723]

Hello,
I have 5 columns, all of them can contain specific word
6th column is numbers.
Is it possible to take all 5 columns, find if cells contain specific word and sum the number if it does.

For example here I want to sum numbers of red only :

red	blue			yellow	5
blue	red	yellow		blue	2
yellow		blue	red		4
green	green		blue	red	8

<tbody>
</tbody>

the result will be 5+2+4+8 =19

I tried Sumproduct (--(A1:E4="red"),F1:F4) And it didn't work.

 

[Special-K99]

=SUMPRODUCT((A1:E4="red")*(F1:F4))

gives 19

NOTE: ALL occurrences of the colour add the row number,

so Blue gives 21
Row 1, 1 occurrence = 5
Row 2, 2 occurrences = 2 + 2
Row 3, 1 occurrence = 4
Row 4, 1 occurrence = 8
= 5 + 2 + 2 + 4 + 8 = 21

 

[szakharov7723]

Thank you ! it really helped and clarified this function