COUNT formula need two conditions

  • Thread starter Thread starter DB Explorer
  • Start date Start date
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
 
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.
 
It was so simple and I was running sorting macros which gave me
trouble!!! thank you JR !!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

two condition formula 1
Excell - two conditions count if factors are true when negative nu 2
Excel How to count from a column if specific condition in another column is true 3
Two Condition - search 2
Conditional count 2
countifs Function not giving desired result with date criteria 2
Excel VBA 1
Formula For Counting Records 5

Back
Top