CODEWITHSUNDEEP
filtergoogle-sheetssumsumifs
Perry_M
Perry_M

Reputation: 137

Google Sheets filter with OR criteria

Can someone please help me with this formula on a Google-Sheet? I am using a filter but I need to add an OR condition. 

  =SUM(filter(H:H, A:A="completed order"))

I want it to include Completed order OR Confirmation.

Upvotes: 1

Views: 162

Answers (2)

ekta bhosale
ekta bhosale

Reputation: 1

You can use "+" in between of the two conditions to use or:

= SUM(filter(H:H, (A:A="condition 1") + (A:A="condition 2")))

Upvotes: 0

JPV
JPV

Reputation: 27262

See if this works

 =SUM(filter(H:H, (A:A="completed order") + (A:A="confirmation")))

Upvotes: 1

Related Questions