The formula shown in H2 is
=SUM(INDEX(($D$1:$D$12=F2)*(MATCH($A$1:$A$12,$A$1:$A$12,0)=ROW($A$1:$A$12)),0))
Data Range
A B C D E F G H 1 Unit Type Privacy Care Level 2 1 alstudio PRI AL AL 2 =SUM(INDEX(($D$1:$D$12=F2)*(MATCH($A$1:$A$12,$A$1:$A$12,0)=ROW($A$1:$A$12)),0)) 3 2 al2br SPA AL DM 3 4 2 al2br SPB AL IL 3 5 3 al1br PRI DM 6 4 al1br SPA DM 7 4 al1br SPB DM 8 5 al2br SPA IL 9 5 al2br SPB IL 10 6 alstudio PRI DM 11 7 al2br PRI IL 12 9 al1br PRI IL
Bookmarks