CODEWITHSUNDEEP
google-sheetsgroup-bysummatchgoogle-query-language
Kirill
Kirill

Reputation: 53

sum values which satisfy conditions in google sheets

I try to do a formulae which should check column A and if in cell value is 1 than formulae should take value in column B and sum with others which satisfy conditions

sheet example)) https://docs.google.com/spreadsheets/d/1hjP1-EgQYvKDOM6wYj_NmFiOXAsaAOAgaFGWf8feJxw/edit?usp=sharing

Upvotes: 1

Views: 89

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(QUERY({A2:A&""\ B2:B}; 
 "select Col1,sum(Col2) where Col1 is not null 
  group by Col1 label sum(Col2)''"))

enter image description here

Upvotes: 1

Related Questions