+ Reply to Thread
Results 1 to 3 of 3

Sum Count of Numeric Criterion

Hybrid View

  1. #1
    Sam via OfficeKB.com
    Guest

    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

  2. #2
    Domenic
    Guest

    Re: Sum Count of Numeric Criterion

    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


  3. #3
    Sam via OfficeKB.com
    Guest

    Re: Sum Count of Numeric Criterion

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1