Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 226
- Office Version
- 365
- Platform
- Windows
I was asked to create formulas to count how often we are replacing components of a tool.
i only have 2 columns Column A, a date is M/D/YYYY format and Column D the component number
here was my 2nd attempt at counting from the sheet after first failed.
=COUNTIFS('984 TCC1 SHEET'!D:D,"6509-1",'984 TCC1 SHEET'!A:A,"<="&DATE(W4,1,1),'984 TCC1 SHEET'!A:A,"<="&DATE(2021,X4,1))
Basically i want to CHOOSE what YEAR and what MONTH that the formula is counting by having dedicated cell one with year and one iwth a drop down list of the month (in the formualr W4 is year, X4 is month)
where am i going wrong in the syntax? my answer should be 4 because theres literally only 4 line items in the test list and all are november htis year and for that part number. but my result is 0
i only have 2 columns Column A, a date is M/D/YYYY format and Column D the component number
here was my 2nd attempt at counting from the sheet after first failed.
=COUNTIFS('984 TCC1 SHEET'!D:D,"6509-1",'984 TCC1 SHEET'!A:A,"<="&DATE(W4,1,1),'984 TCC1 SHEET'!A:A,"<="&DATE(2021,X4,1))
Basically i want to CHOOSE what YEAR and what MONTH that the formula is counting by having dedicated cell one with year and one iwth a drop down list of the month (in the formualr W4 is year, X4 is month)
where am i going wrong in the syntax? my answer should be 4 because theres literally only 4 line items in the test list and all are november htis year and for that part number. but my result is 0