Sum Count of Numeric Criterion

  • Thread starter Thread starter Sam via OfficeKB.com
  • Start date Start date
S

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
 
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 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.
Click to expand...

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,
Click to expand...
[quoted text clipped - 8 lines]
Thanks,
Sam
Click to expand...
Click to expand...
 
Back
Top