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 :
[TABLE="width: 500"]
<tbody>[TR]
[TD]red[/TD]
[TD]blue[/TD]
[TD][/TD]
[TD][/TD]
[TD]yellow[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]blue[/TD]
[TD]red[/TD]
[TD]yellow[/TD]
[TD][/TD]
[TD]blue[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]yellow[/TD]
[TD][/TD]
[TD]blue[/TD]
[TD]red[/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]green[/TD]
[TD]green[/TD]
[TD][/TD]
[TD]blue[/TD]
[TD]red[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

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