Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- A
- 12/7/2012 B 100
- 12/21/2012 I 20
- 12/23/2012 I 25
- 12/1/2013 I 20
- 12/1/2014 I 20
- 12/20/2014 S -100
- V
- 12/7/2012 B 200
- 12/21/2012 I 40
- 12/23/2012 I 50
- 12/1/2013 I 40
- 12/1/2014 I 40
- S
- =SUMPRODUCT((YEAR(A1:A12)=F2)*(B1:B12= F3)*C1:C12)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement