Hi Pravin,
Pls Note below steps what I did.
in Column C
=A2B2drag it up to C10
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to D10
Now in Cell B11 I Wrote : =SUM((B2:B11)*(D2:D11=1)) with Ctrl+Shift+Enter
Regards
Prince
On Wednesday, October 3, 2012 10:38:03 AM UTC+5:30, Pravin Gunjal
*Hello Prince*
*
*
*This is also working fine with a small changes in the cell's address as
follows :-*
*
*
in Column C
=A2B2drag it up to* C11*
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to *D11*
Now in Cell *B12* I Wrote : =SUM((B2:B11)*(D2:D11=1)) with Ctrl+Shift+Enter
*
*
*Thank you.*
*