View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sriram R
 
Posts: n/a
Default Multiple conditions data analysis

I have a database of 50 columns and 4000 rows. I am trying to calculate the
number of rows that match multiple criteria. For example:
If column A < 0.5, Column B=0 and Column C: between 2/1/06 - 3/1/06.
Note that not all cells have data and are blank. Say some cells with A < 0.5
will not have any value for B.