=SUMIF(A2:INDEX(A:A,SMALL(IF(A:A="yes",1,1000)*ROW(A:A),3)),"Yes",C2:INDEX(C:C,SMALL(IF(A:A="yes",1,1000)*ROW(A:A),3)))
Jesus - it works!Hi,
Welcome to the Board!
Please test the following formula:
=SUMIF(A2:INDEX(A:A,SMALL(IF(A:A="yes",1,1000)*ROW(A:A),3)),"Yes",C2:INDEX(C:C,SMALL(IF(A:A="yes",1,1000)*ROW(A:A),3)))
You have to confirm it using Ctrl-Shift-Enter.
Thank you, it works!First one:
=SUMIF(A2:INDEX(A2:A10,AGGREGATE(15,6,(ROW(A2:A10)-ROW(A2)+1)/(A2:A10="yes"),3)),"yes",C2:C10)
Have to go. Will come back to the second one later if not resolved.
=SUMIFS(C2:INDEX(C:C,SMALL(IF((A:A="yes")+(B:B="yes")=2,1,1000)*ROW(A:A),3)), A2:INDEX(A:A,SMALL(IF((A:A="yes")+(B:B="yes")=2,1,1000)*ROW(A:A),3)),"Yes", B2:INDEX(B:B,SMALL(IF((A:A="yes")+(B:B="yes")=2,1,1000)*ROW(A:A),3)),"Yes")