I want to compare two coloumn particular text, then count total
in [Functions]
|
Prev: More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
Next: Columns labeled with numbers not letters
From: Ashraf C.H. Ashraf C.H. on 22 Apr 2010 08:02 I would like to compare two different coloumn particular text then count total example: A1= "IN" , D1= "RES" A2= "FI" , D2= "SBK" A3= "IN", D3="RES" i would like to compare above coloumn i.e. how many "in" = RES, how many "FI"= sbk please help me
From: Duke Carey on 22 Apr 2010 08:22 Hi - try: =sumproduct(--(A1:A100="IN"),--(B1:B100="RES")) You could also generate a pivot table out of your columns taht would count all the combiantions of values "Ashraf C.H." wrote: > I would like to compare two different coloumn particular text then count total > example: > A1= "IN" , D1= "RES" > A2= "FI" , D2= "SBK" > A3= "IN", D3="RES" > > i would like to compare above coloumn i.e. how many "in" = RES, how many > "FI"= sbk > please help me
From: Eduardo on 22 Apr 2010 08:27 Hi, =sumproduct((A1:A10="IN")*(D1:D10="RES")) "Ashraf C.H." wrote: > I would like to compare two different coloumn particular text then count total > example: > A1= "IN" , D1= "RES" > A2= "FI" , D2= "SBK" > A3= "IN", D3="RES" > > i would like to compare above coloumn i.e. how many "in" = RES, how many > "FI"= sbk > please help me
From: Dave Peterson on 22 Apr 2010 08:55
And if you're using xl2007, then you could look at =countifs() Ashraf C.H. wrote: > > I would like to compare two different coloumn particular text then count total > example: > A1= "IN" , D1= "RES" > A2= "FI" , D2= "SBK" > A3= "IN", D3="RES" > > i would like to compare above coloumn i.e. how many "in" = RES, how many > "FI"= sbk > please help me -- Dave Peterson |