Is there some sort of equivalent to a =query ...

[Steven_Jeffery]

Is there some sort of equivalent to a =query type calculation in google sheets, in app sheet?

I want to find the total qnty of similiar filter sizes on various equipment.