J
jh
Hi
Excel Office 2003
Summary Page is Worksheet 1, Worksheet 2 contains data for year 2010,
Worksheet 3 contains data for year 2011, etc. In each data worksheet, Column
P contains dates (column is formatted as dates 01/01/10), Column M contains
either "Yes" or "No" and Column G contains either "Active" or "Inactive" On
the summary page, I need to count the number of rows that contain "Yes" in
Column M and "Inactive" in Column G for the 2nd quarter of year 2010. I have
tried several SumProduct formulas I've seen here to no avail. Not sure what
I am doing wrong.
G M P
Inactive Yes 04/04/10
Should count as 1 for 2nd quarter of 2010 but using either formula I've seen
here keeps counting as 1 for 1st quarter of 2010.
Excel Office 2003
Summary Page is Worksheet 1, Worksheet 2 contains data for year 2010,
Worksheet 3 contains data for year 2011, etc. In each data worksheet, Column
P contains dates (column is formatted as dates 01/01/10), Column M contains
either "Yes" or "No" and Column G contains either "Active" or "Inactive" On
the summary page, I need to count the number of rows that contain "Yes" in
Column M and "Inactive" in Column G for the 2nd quarter of year 2010. I have
tried several SumProduct formulas I've seen here to no avail. Not sure what
I am doing wrong.
G M P
Inactive Yes 04/04/10
Should count as 1 for 2nd quarter of 2010 but using either formula I've seen
here keeps counting as 1 for 1st quarter of 2010.