szakharov7723
Board Regular
- Joined
- Jun 22, 2018
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
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 :
<tbody>
</tbody>
the result will be 5+2+4+8 =19
I tried Sumproduct (--(A1:E4="red"),F1:F4) And it didn't work.
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.