Hi
I have someting like this:
<tbody>
</tbody>
but with hundreds of rows.
I want to sum the "amount" column only if the "name" column does not contain the words "josh" or "andy".
the result for example in this case should be:
320.0 ("emma") + 215.5 ("larry") + 285.8 ("Willy") = 821.3
I tried with SUMIF and INDEX but got totally lost.
please help ?
I have someting like this:
NAME | AMOUNT |
---|---|
josh | 454.1 |
emma | 320.0 |
andy | 115.5 |
larry | 215.5 |
Willy | 285.8 |
<tbody>
</tbody>
but with hundreds of rows.
I want to sum the "amount" column only if the "name" column does not contain the words "josh" or "andy".
the result for example in this case should be:
320.0 ("emma") + 215.5 ("larry") + 285.8 ("Willy") = 821.3
I tried with SUMIF and INDEX but got totally lost.
please help ?