Hi all, hoping you can help me. I want to sum cells within a range, only if 3 criteria are met, but each criteria is specific to finding specific text within other cells in the same row. For example:
<tbody>
</tbody>
I would like to create a formula that sums the numbers in column 'Count' if the following criteria are met for column 'Set 1' and 'Set 2':
'Set 1' - Cell contains the word "fruit"
'Set 2' - Cell contains the word "apple" AND "red"
In this example, the formula should return "6."
Apologies, I know the example looks a bit weird.
Would really appreciate your help! Thanks in advance.
Set 1 | Set 2 | Count |
Good fruit | This apple is red | 5 |
Bad fruit | This apple is green | 6 |
Bad dessert | This cake is red | 8 |
Good meat | This beef is red | 3 |
Bad fruit | This apple is red | 1 |
<tbody>
</tbody>
I would like to create a formula that sums the numbers in column 'Count' if the following criteria are met for column 'Set 1' and 'Set 2':
'Set 1' - Cell contains the word "fruit"
'Set 2' - Cell contains the word "apple" AND "red"
In this example, the formula should return "6."
Apologies, I know the example looks a bit weird.
Would really appreciate your help! Thanks in advance.