help me getting value of column based on condition

A

amrezzat

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,
 
R

RagDyeR

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!
=====================================================

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,
 
B

bpeltzer

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).
 
Top