COUNT formula need two conditions
 

I have a database dump, which column B having different names of users,
and column C having values either TRUE or FALSE...I want a count of all
records, which have the name "James" and have the corresponding
Column C value as TRUE..

Please help how I can do this. I know how to use a COUNTIF, but only
with one condition. In this case there are 2..

Regards
Sunil

COUNT formula need two conditions
 

Try this. In the next column to the right, Type the formula =A1&B1 then copy
it to the bottom of your data. You will a criteria of "JamesTrue" for your
count formula.

"DB Explorer" wrote:

I have a database dump, which column B having different names of users,
and column C having values either TRUE or FALSE...I want a count of all
records, which have the name "James" and have the corresponding
Column C value as TRUE..

Please help how I can do this. I know how to use a COUNTIF, but only
with one condition. In this case there are 2..

Regards
Sunil

COUNT formula need two conditions
 

Cool....Thanks for this !! it was quick

COUNT formula need two conditions
 

It was so simple and I was running sorting macros which gave me
trouble!!! thank you JR !!!!