DCMADiva87
New Member
- Joined
- Aug 3, 2010
- Messages
- 2
Hello,
I am having trouble getting the following formula work for the month of January: =SUMPRODUCT(--(TEXT('Definitized UCAs'!$L$3:$L$6000,"mmm")=B16))
It is counting the number of definitized items per month for the fiscal year (October 2009 - September 2010), B16 refers to the month of October, C16 is November and so on. It works for every month but January 2010. Can anyone help me with my problem?
I am having trouble getting the following formula work for the month of January: =SUMPRODUCT(--(TEXT('Definitized UCAs'!$L$3:$L$6000,"mmm")=B16))
It is counting the number of definitized items per month for the fiscal year (October 2009 - September 2010), B16 refers to the month of October, C16 is November and so on. It works for every month but January 2010. Can anyone help me with my problem?