can sumproduct use a countif result as a variable?

[jeepjenn]

I have a large data sheet in which I use countif to determine the number of rows with data in column A

Is it possible to use it in a sumproduct formula such as this: =SUMPRODUCT((Data!$N$2:$N$7492=$X$54)*(Data!$Y$2:$Y$7492=V60)*1)

This sumproduct counts the number of classification codes listed in column N, and then checks to see if they reside in the prov of Alberta in column Y

Basically, I want the sumproduct to self-adjust using the countif result...

Is there a better way???

 

[Aladin Akyurek]

Try something like...

=COUNTIFS(Data!N:N,X$54,Data!Y:Y,V60)

 

[jeepjenn]

Thank YOU!! Thank YOU!! Thank YOU!!

 

[Aladin Akyurek]

Thank YOU!! Thank YOU!! Thank YOU!!

You are welcome.