COUNT formula need two conditions

D

DB Explorer

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
 
J

JR

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.
 
D

DB Explorer

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