Google Sheets – Filter Column Based on Another Column Using Query

I think, you need the combination of formulas. The answer is:

={QUERY({A:C},"select Col1, sum(Col2) where Col1 <>'' group by Col1"),{"filtered sum";ArrayFormula(IFERROR(VLOOKUP(UNIQUE(FILTER(A2:A,A2:A<>"")),QUERY({A:C},"select Col1, sum(Col2) where Col3 ='yes' group by Col1") ,2,0),0))}}

Explanation

It's not hard if you'll take it by parts:

• ={basic query, {"header"; vlookup(a, help query, 2, 0) }}

Basic query

QUERY({A:C},"select Col1, sum(Col2) where Col1 <>'' group by Col1")

It's simple, I've used Col1, Col2... notation to make it work with any range.

Vlookup

IFERROR(VLOOKUP(UNIQUE(FILTER(A2:A,A2:A<>"")), help query ,2,0),0))

We count sums with criteria (c = 'yes') in the help query.

UNIQUE(FILTER(A2:A,A2:A<>"")) part of the formula gives you a list from column 'a'.

Help query

QUERY({A:C},"select Col1, sum(Col2) where Col3 ='yes' group by Col1")

Here you may enter any conditions what you want. In this case it's Col3 ='yes'

OP presumably did try what was recommended in a Comment, found that satisfactory, and never bothered to report back. For the sake of an answer:

=query(importrange(" k e y ","CAT!A:R"),"select * where Col2 <> 'Secondary'")

k e y need not be the entire URL. Just the part that looks like this is sufficient:

1MiNSa3xN5sjAo43zt-oU4gzjaRfYwFQ-lbGWkZi5z64

No need to specify the first row of the source when whole columns are involved.
Since acquired with IMPORTRANGE columns can't be referenced by just letters (ie must be Col2 (case sensitive) rather than B).
The exclusion term (Secondary) is case sensitive.

Since acquiring all rows blank in ColumnB of the source it may be a good idea to add further provision, such as specifying a sort order, to avoid all (if any) empty rows rising to the top.