Ok I am working on a very large sheet trying to count how many time a value appear in a given year.
My work area covers A1:Q73052
I want to count how many time a value lets say 1 is in column Q
but at the same time I only want to count the value if it is in a given year lets say 2017 in column D
so countif Q2:Q73052 = 1 and only if D2:D73052 = 2017
Bookmarks