Aap k problem k leye waise tu bohat se method hain. Leekan 3 easy ways.
1. As per your sample data agar duplicate aik dosra k neeche hain tu try this
Code:
=IF(A2=A1,"",SUMPRODUCT(--($A$2:$A$4=A2),--($B$2:$B$4=B2),--($C$2:$C$4=C2)))
2. Agar duplicate aik dosre k neeche nahee hain tu try this traditional function
Code:
=SUMPRODUCT(--($A$2:$A$4=A2),--($B$2:$B$4=B2),--($C$2:$C$4=C2))
3. Ye tradional sumproduct se bohat zayada fast formula ha. Is ko enter karne k leye aap forumla copy karain/ya lekhain tu phir "Contorl+shift+Enter" Aik saath press karain aur formula ko neeche jahan tak require he copy kar dain
Code:
=SUM(($A$2:$A$4=A2)*($B$2:$B$4=B2)*($C$2:$C$4=C2))
Note: Ranges/refrences ko zarrorat k mutabiq change kar lain. Dosra Apni ranges ko absolute karain warna aap ka post NO.1 k formula k tarah wrong answer mele ga.
Behtar ho ga k aap screen shot dain ya apni file attached karain.
regards
Bookmarks