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))
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))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks