Filter sum with an OR statement?

codebreaker 0
Viewed 28

=SUM(H33:H41)+SUM(I33:I41)+ FILTER(Transactions!F:F,Transactions!C:C="Deposit")

The snippet above works fine, but I am getting errors when I try to add a filter for "Withdrawal".

=SUM(H33:H41)+SUM(I33:I41)+FILTER(Transactions!F:F,Transactions!C:C="Deposit")+FILTER(Transactions!F:F,Transactions!C:C="Withdrawal")

if-statement filter google-sheets
1 Answers

use:

=SUM(H33:I41)+FILTER(Transactions!F:F, REGEXMATCH(Transactions!C:C, "Deposit|Withdrawal"))
player00
Related