| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum(if(a1=b1,1,0),if(a2=b2,1,0),if(a3=b3,1,0),... ..)
I have 2 columns
A B 1 a a 2 d d 3 c a I want to know how many lines A=B -this must be an numerical value -in this case 2 =sum(if(a1=b1,1,0),if(a2=b2,1,0),if(a3=b3,1,0),... ..) is a solution But simply is more usefully :D Anyone can help me pls? |
Threaded Mode
