Originally Posted by Special-K Assuming you know the last occupied cell, e.g. A10, or how far down the data will fill. This will ignore blanks as well. =SUMPRODUCT(((MONTH(A1:A10)<>MONTH(A1))+(YEAR(A1:A10)<>YEAR(A1)))*(A1:A10<>0)) Good afternoon, Thank you for this, however, I can't get it to work. It only returns zero. I have attached some sample data for ease. Kind regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks