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
|