Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {=SUM(IF(A2:A9=C2,B2:B9,0),IF(A2:A9=C3,B2:B9,0))}
- {=SUM(IF(A2:A9={"A","B"},B2:B9,0))}
- {=SUM(IF(A2:A9=C2:C3,B2:B9,0))}
- {=SUM(IF(A2:A9=INDIRECT("C2:C3"),B2:B9,0))}
- {=SUM(IF(A2:A9=C2:C9,B2:B9,0))}
Add Comment
Please, Sign In to add comment