#VALUE! Countifs

[jwgreen1986]

im getting #Value ! when doing a countifs. anything i am missing. i am basically wanting it to count the totals for jan when Q5-Q29991 = "yes", sales AC = a value in a cell, sales R5 = "new" and the sale date (AB) is in january.

i have this formula in another section for the sales execs and it is counting there up fine. it isnt working when im trying to do it by site though.

=COUNTIFS(Sales!$Q$5:$Q$29991,"YES",Sales!$AC$5:$AC$1048576,BX4,Sales!$R$5:$R$29991,"New",Sales!$AB$5:$AB$29991,">=01/01/2019",Sales!$AB$5:$AB$29991,"<=31/01/2019")

 

[jwgreen1986]

sorted this now. it was the range for AC. it didnt like the huge number so changed it to :$AC$29991