Sum Count of Numeric Criterion
 

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


--
Message posted via http://www.officekb.com

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

Hi Domenic,

That worked great! Thank you very much.

Domenic wrote:
Try...

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

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

Cheers
Sam

Domenic wrote:
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


--
Message posted via http://www.officekb.com