Hi,

u can get around this by using additional column to find out if column A
column B and count the TRUE values.

A B C
1 4 =A1B1
2 3 =A2B2
3 2 =A3B3
4 1 =A4B4

=countif(C1:C4,TRUE)

hope this helps.


"Neffa" wrote:

struggling here