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

Tim,

Use a formula like

=SUMPRODUCT(--(K1:K100="tim"),--(L1:L100="clever"))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Tim3057"
wrote in message
...

Hi,

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

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

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

Thanks

Tim


--
Tim3057
------------------------------------------------------------------------
Tim3057's Profile:
http://www.excelforum.com/member.php...o&userid=30403
View this thread:
http://www.excelforum.com/showthread...hreadid=500727