Hi,

I'm trying to COUNTIF in one range at the same time as COUNTIF i
another, and put the answer in one cell.

In English, the formula might be: Count if K1:K900 is 'tim' and K1:K90
is 'clever'.

To return how many times tim is clever. (For example. I know that, i
fact, Tim is actually quite dim)

Thanks

Ti

--
Tim305
-----------------------------------------------------------------------
Tim3057's Profile: http://www.excelforum.com/member.php...fo&userid=3040
View this thread: http://www.excelforum.com/showthread.php?threadid=50072