In excel 2010, I have 2 spreadsheets, the first "Daily Count Aug 2016" has the data, the second, "NEW COUNT" has a reporting chart. A cell on "New COUNT" contains the following formula:
=COUNTIFS('[Daily Count Aug 2016.xlsx]Daily Count'!$C$2:$C$2500,"<=D",'[Daily Count Aug 2016.xlsx]Daily Count'!$D$2:$D$2500,"<>L",'[Daily Count Aug 2016.xlsx]Daily Count'!$F$2:$F$2500,$A7)
What this is supposed to do is:
1. filter out all of the cells in column c that contain either C or D
2. of those, filter out all of the cells in column D that do not contain L, but does contain E, N or Y
3. of those, count the number of cells in column F that contain a date (A7)
The value returned is 79, which is incorrect. It should be 29, however the only way I can return that value is using <n instead="" of="" <="">L, which neglects the E value in the search.
Is it the order of the formula, or do I need to add additional search parameters?</n>
=COUNTIFS('[Daily Count Aug 2016.xlsx]Daily Count'!$C$2:$C$2500,"<=D",'[Daily Count Aug 2016.xlsx]Daily Count'!$D$2:$D$2500,"<>L",'[Daily Count Aug 2016.xlsx]Daily Count'!$F$2:$F$2500,$A7)
What this is supposed to do is:
1. filter out all of the cells in column c that contain either C or D
2. of those, filter out all of the cells in column D that do not contain L, but does contain E, N or Y
3. of those, count the number of cells in column F that contain a date (A7)
The value returned is 79, which is incorrect. It should be 29, however the only way I can return that value is using <n instead="" of="" <="">L, which neglects the E value in the search.
Is it the order of the formula, or do I need to add additional search parameters?</n>
