I want to compare two coloumn particular text, then count total

  • Thread starter Thread starter Ashraf C.H.
  • Start date Start date
A

Ashraf C.H.

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
 
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
 
Back
Top