CountIf

[luis.carrion]

Hello,

I need a formula that will show the numbers of how many people completed their inventory by month. In the Dashboard Tab in Column M17 i need the count of the completed date from Tab SCA FY17 column J9. AM trying to create a time line that will show how many people completed the inventory by month. in Tab SCA FY17 from J9 to J23 i have the completion dates in this format: 11/1/2016 and i need the count in the Dashboard Tab

 

[texasalynn]

post a small sample of data

 

[luis.carrion]

basically in sheet name"SCA FY17"
Column: J5:J23 I have a dated formatted like "12/1/2016",

in Sheet name "Dashboard"

Column: V31 i need a formula that will count the dates between 12/1/2016 and 12/31/2016

 

[63falcondude]

basically in sheet name"SCA FY17"
Column: J5:J23 I have a dated formatted like "12/1/2016",

in Sheet name "Dashboard"

Column: V31 i need a formula that will count the dates between 12/1/2016 and 12/31/2016

Although that is not a small sample of data, give this a try:

=COUNTIFS('SCA FY17'!$J$5:$J$23,">="&DATE(2016,12,1),'SCA FY17'!J5:J23,"<="&DATE(2016,12,31))

 

[texasalynn]

try this formula
=COUNTIFS('SCA FY17'!J5:J23,">="&DATE(2016,12,1),'SCA FY17'!J5:J23,">="&DATE(2016,12,31))

 

[luis.carrion]

Hello the formula works, the only problem is that when i change it for the month of January its also ready the earlier months. i need to only read December but if i change the dates to November i need to only that date range. For example i change the formula to read any dates for October but when i place the formula In M18 thats for the month of November it also reads October and if i change it to read only December it reads Oct and November and so on.

 

[texasalynn]

post how you have the formula

 

[texasalynn]

both of these work
=COUNTIFS('SCA FY17'!$J$5:$J$23,">="&DATE(2016,12,1),'SCA FY17'!J5:J23,"<="&DATE(2016,12,31))
=SUMPRODUCT(--('SCA FY17'!J5:J23>=DATE(2016,10,1)),--('SCA FY17'!J5:J23<=DATE(2016,10,31)))

 

[luis.carrion]

Thank you