Sum Count of Numeric Criterion

[Sam via OfficeKB.com]

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

 

[Domenic]

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!

 

[Sam via OfficeKB.com]

Hi Domenic,

That worked great! Thank you very much.

Try...

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

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

Cheers
Sam

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!

Hi All,

[quoted text clipped - 8 lines]

Thanks,
Sam