SUMPRODUCT(MOD(ROW. The number of cells >0 matching a criteria

[ozbeachbum]

Hi All,
I am endeavouring to find the number of cells in the range AN70:AN332 that are >0 and Match]ng the Criteria of =0 in D70:D322.
My best effort was:
=SUMPRODUCT((MOD(ROW(AN70:AN322)-70,6)=0)*(D70:D322=0)*(AN70:AN322>0),(AN70:AN322))
but it adds the value of the cells in "Column AN", where as I only want to know the number of cells that are >0
Any assistance greatly appreciated.
Cheers,
Dave.

 

[kevin9999]

Does a simple countifs not give you the count you're looking for?

=COUNTIFS(D70:D322,0,AN70:AN322,">0")

 

[ozbeachbum]

Thank you, yes it does.
Simple always the best.
Cheers,
Dave.

 

[kevin9999]

You're welcome Dave, thanks for the feedback