most
Board Regular
- Joined
- Feb 22, 2011
- Messages
- 107
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
Hello!
Can anyone help me explain what's wrong here and how to solve it?
My expectation is that the code should count occurrence of a specific month of the dates in the green field(named_range).
Month 2-12 works fine, but month 1 return the number of rows in the named range minus occurrence of the other months, in this case 6.
If there is a better way to solve it, i'm all ears.
regards Marcus
Can anyone help me explain what's wrong here and how to solve it?
Code:
{=SUM(IF(MONTH(named_range)=C3,1))}
![jjsaip.jpg](/board/proxy.php?image=http%3A%2F%2Fi66.tinypic.com%2Fjjsaip.jpg&hash=fdf885530437aad7ec018fb0ab2808b0)
My expectation is that the code should count occurrence of a specific month of the dates in the green field(named_range).
Month 2-12 works fine, but month 1 return the number of rows in the named range minus occurrence of the other months, in this case 6.
If there is a better way to solve it, i'm all ears.
regards Marcus