Help with COUNTIF

[MRozell]

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

[benishiryo]

hi MRozell. does column D contain a date or simply the year? if it's the former:
=SUMPRODUCT(($Q$2:$Q$73052=1)*(YEAR($D$2:$D$73052)=2017))

if it's the latter:
=COUNTIFS($Q$2:$Q$73052,1,$D$2:$D$73052,2017)

[sandy666]

try with COUNTIFS()

too late

[guru008]

Hi,

Try countifs here

=COUNTIFS(Q:Q,1,D:D,">=1/1/2017",D:D,"<=12/31/2017")