Thanks for the rapid response - I was kinda hoping that I might avoid some
"hidden" columns but your work around appears to be the most elegant solution
available.

Thanks again.
Neffa

"Yong Heng" wrote:

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