Hi All,
I have a problem with the formulae SUMPRODUCT, it seems to be miscounting? Now I am sure there is somehting silly I have missed, but I could really do woth someone else taking a glance over it before I have to look at another option to get the result I need.
The ultimate goal here is to count how many occurences happen in each month, there is a list in Sheet1 of the attached Excel document, then in Sheet2 there is the two different formulae's I have tried, but the count is wrong? For teh first month of instances June 2012 it counts 20, but there are 21? and there are other instances similar throughout.
Any help would be much appreciated, thanks all.
Sincerely,