![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Take a look at the attached.
|
#3
|
|||
|
|||
![]()
Thanks Xor, most appreciated
|
![]() |
Tags |
countifs, date, time |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filter not returning all relevant results | hnhorner | Excel | 3 | 07-12-2015 05:33 PM |
![]() |
ubns | Excel | 1 | 04-16-2015 02:00 PM |
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
![]() |
jaden0605 | Excel | 1 | 03-30-2014 01:50 AM |
![]() |
TerryStevenson | Excel | 1 | 09-16-2013 12:20 PM |