View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DB Explorer
 
Posts: n/a
Default 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