I need to sum specific cells in 1 column (Q) based on if the other columns (R, S) have a certain word(s) within the cell.
For example in the picture if a cell in R or S contains the word toy or green, then it needs to sum the specified data from column Q.
I have tried using different variations of sumif-filter-regexmatch but I still can not get it to work with multiple conditions. If there is another set of formulas to use please show me.
P.S (I need the sum from the Q column not the count of cells)