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