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

Try these:

=COUNTIF(A:A,1)

=SUMIF(A:A,1,B:B)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"amrezzat" wrote in
message ...

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

Count the number of times using countif: =countif(a:a,1).
Total the associated entries from column B using sumif: =sumif(a:a,1,b:b).


"amrezzat" wrote:


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