CODEWITHSUNDEEP
if-statementgoogle-sheetsfilter
user11067130
user11067130

Reputation:

Filter sum with an OR statement?

=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")

Upvotes: 0

Views: 42

Answers (1)

player0
player0

Reputation: 1

use:

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

Upvotes: 1

Related Questions