heloo
help me in that please
if i have these 2 coulmns


1 1000
2 1222
3 200
1 100
2 200
3 300
4 400

i want to calculate how many 1 appears
and the total of all value in the second colum in 1
so the results will be 2 times
1000+100=1100

please tell me in details how to do that,


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=484555