Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2017, 10:16 AM
rgauss rgauss is offline COUNTIFS function is only returning partial results Windows 7 64bit COUNTIFS function is only returning partial results Office 2013
Novice
COUNTIFS function is only returning partial results
 
Join Date: May 2016
Posts: 6
rgauss is on a distinguished road
Default 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
Attached Files
File Type: xlsx For the group.xlsx (8.9 KB, 12 views)
Reply With Quote
  #2  
Old 01-25-2017, 11:16 AM
xor xor is offline COUNTIFS function is only returning partial results Windows 10 COUNTIFS function is only returning partial results Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Take a look at the attached.
Attached Files
File Type: xlsx For the group_2.xlsx (17.0 KB, 13 views)
Reply With Quote
  #3  
Old 01-25-2017, 01:26 PM
rgauss rgauss is offline COUNTIFS function is only returning partial results Windows 7 64bit COUNTIFS function is only returning partial results Office 2013
Novice
COUNTIFS function is only returning partial results
 
Join Date: May 2016
Posts: 6
rgauss is on a distinguished road
Default

Thanks Xor, most appreciated
Reply With Quote
Reply

Tags
countifs, date, time



Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter not returning all relevant results hnhorner Excel 3 07-12-2015 05:33 PM
COUNTIFS function is only returning partial results COUNTIFS returning Value Error 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
COUNTIFS function is only returning partial results multiple conditions, and blank cells with the countifs function jaden0605 Excel 1 03-30-2014 01:50 AM
COUNTIFS function is only returning partial results Scores returning ranked results TerryStevenson Excel 1 09-16-2013 12:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft