Try...

=SUMPRODUCT((MOD(ROW(D46:AZ75)-ROW(D46),3)=0)*(D46:AZ75=A1))

....where A1 contains your criterion. Adjust the range accordingly.

Hope this helps!

In article ,
"Sam via OfficeKB.com" wrote:

Hi All,

I wish to sum the count of a numeric criterion across and down numerous non-
consecutive Rows. The Rows of Data to be counted and summed is on every 3rd
Row; starting at Row 46 - D46:AZ46, D49:AZ49, D52:AZ52 etc. Over 30 Rows to
count and sum.

I tried a combination of Sumproduct, Offset and Mod but could not return the
correct result.

Thanks,
Sam