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 <54B2B11DC5910@OfficeKB.com>,
"Sam via OfficeKB.com" <forum@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