Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- AB0010
- CC0009
- AB0010
- EF0011
- CC1001
- AB0090
- CC1001
- (empty field)
- CC1001
- CC2001
- AB = 2
- CC = 3
- EF = 1
- =SUM(IF(LEFT($A$1:$A$10,2)=D1,1/COUNTIFS($A$1:$A$10,$A$1:$A$10,$A$1:$A$10,D1&"*")))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement