COUNTIFS function is only returning partial results
Good day to you -
I am using the COUNTIFS function against a single column of data to find the number of events per month.
A typical column entry looks like this - 09/26/2016 7:51 and the cell is formatted as custom mm/dd/yyyy h:mm
The COUNTIFS I am using here is =COUNTIFS(A2:A28,">=09/26/2016",A2:A28,"<=09/30/2016") as there are 28 cells in the column with a September date. Using this function however only nets 21 counts, not 28.
Please open the attached 'for the group.xlsx' and you will see the formula and result.
I have the same issue for October as well and oddly NOV, DEC and January-to-date are correct (not part of the attached). If you wish I can attached the entire sheet but thought if we could resolve this issue with September only then I can apply that to the rest of the sheet.
Please let me know what you think and I thank you for your time on this.
Rob
|