|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 8th, 2005, 07:35 PM
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
December 8th, 2005, 07:46 PM
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
December 8th, 2005, 07:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT formula need two conditions
Cool....Thanks for this !! it was quick
|
|
#4
December 8th, 2005, 07:52 PM
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 !!!!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Match then lookup | Tenacity | Worksheet Functions | 10 | December 3rd, 2005 05:30 AM |
| Formula for multiple conditions | Roy | General Discussion | 3 | June 9th, 2005 08:19 PM |
| Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |
| Formula to count age by month | frankgh | Worksheet Functions | 1 | March 10th, 2004 03:27 PM |
| Convert a sum formula to a count formula | Peo Sjoblom | Worksheet Functions | 1 | March 10th, 2004 06:50 AM |
Linear Mode
