One way:
=SUMPRODUCT(--(K1:K900="tim"),--(J1:J900="clever"))
See
http://www.mcgimpsey.com/excel/doubleneg.html
for a fuller explanation.
In article ,
Tim3057 wrote:
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 J1:J900
is 'clever'.
To return how many times tim is clever. (For example. I know that, in
fact, Tim is actually quite dim)
Thanks
Tim