Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT formula need two conditions
Cool....Thanks for this !! it was quick
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT formula need two conditions
It was so simple and I was running sorting macros which gave me
trouble!!! thank you JR !!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count If Formula | Excel Discussion (Misc queries) | |||
Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
Advanced unique cell count with multiple conditions ... help! | Excel Worksheet Functions | |||
Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
A counting formula that won't count multiple instances of same val | Excel Worksheet Functions |