How to compute the value based on criteria of other cells In Google Sheet Query?

Question

In Google Sheet Query, how to compute the value based on criteria of other cells?

Thanks.

I need to add Mary's all pass_A, but not Mary's pass_B. I don't know how to describe it, sorry — user2988464, Feb 16 '21 at 14:59

score 2 · Answer 1 · answered Feb 16 '21 at 15:10

2

Try the following

=QUERY({A2:D6}, 
"select Col1, Col2, sum(Col3), sum(Col4) where Col1 is not null 
 group by Col1, Col2 
 label sum(Col3) '', sum(Col4) '' ",0)

answered Feb 16 '21 at 15:10

marikamitsos

score 1 · Answer 2 · answered Feb 16 '21 at 15:01

1

try:

=QUERY(QUERY(A1:D; 
 "select A,B,sum(C),max(D) 
  where A is not null 
  group by A,B");
 "offset 1"; 0)

answered Feb 16 '21 at 15:01

player0

I think OP is also taking the sum of D like on C instead of it's max. – NightEye Feb 16 '21 at 15:56

2 Answers2