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.
|