countif AND countif something else too!

[Tim3057]

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

[JE McGimpsey]

One way:

=SUMPRODUCT(--(K1:K900="tim"),--(J1:J900="clever"))


See

http://www.mcgimpsey.com/excel/doubleneg.html

for a fuller explanation.

In article <[email protected]>,
Tim3057 <[email protected]> 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