countif AND countif something else too!
 

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


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

countif AND countif something else too!
 

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