Getting stuck with the between two dates, just returning 0 as value. I need a formula for the highlighted column in the attached.
The count needs to reset at each calendar year.
Getting stuck with the between two dates, just returning 0 as value. I need a formula for the highlighted column in the attached.
The count needs to reset at each calendar year.
Try this:
=COUNTIFS(C$2:C2,C2,A$2:A2,">="&DATE(YEAR(A2),1,1),B$2:B2,"<="&DATE(YEAR(A2),12,31))
Thank you. It works beautifully.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks