Forum Discussion
Formula help - why doesn't this work for January dates please?
Hi, I was kindly given this formula to count when a month occurs across two columns. For some reason it comes up with a random total for the month of January, and I don't know how to resolve it. the ...
Please clarify what this odd formula is trying to achieve.
Both MONTH functions return an array of TRUE or FALSE if the dates in the ranges are in December (true) or not (false). Then adding them together results in an array of 0's, 1's or 2's. For instance, if the fist date in E falls in December but the first one in H does not it returns 1 + 0 = 1 for that instance.
No need for the double "--" and what is SUMPRODYCT supposed to do? Don't you just want to SUM the resulting array?
And what 'random total' do you get for January?
Share your file or at least add a screenshot so that we can see what you are working on.