+ Reply to Thread
Results 1 to 11 of 11

Count cells that are a perfect multiple of adjacent cell?

  1. #1
    Registered User
    Join Date
    08-13-2018
    Location
    Edmonton, Canada
    MS-Off Ver
    13
    Posts
    16

    Count cells that are a perfect multiple of adjacent cell?

    Any ideas on how i would count cells where one cell is a perfect multiple of the adjacent cell?

    Basically counting a cell with a whole number.
    Last edited by Jango Fett; 01-11-2019 at 06:25 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,859

    Re: Count cells that are a perfect multiple of adjacent cell?

    Something like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    08-13-2018
    Location
    Edmonton, Canada
    MS-Off Ver
    13
    Posts
    16

    Re: Count cells that are a perfect multiple of adjacent cell?

    That doesn't seem to work for me. Probably because i dont understand it. Do you know how i can attach the example to make this easier?

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,859

    Re: Count cells that are a perfect multiple of adjacent cell?

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Registered User
    Join Date
    08-13-2018
    Location
    Edmonton, Canada
    MS-Off Ver
    13
    Posts
    16

    Re: Count cells that are a perfect multiple of adjacent cell?

    Hope there is an attachment with this.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-13-2018
    Location
    Edmonton, Canada
    MS-Off Ver
    13
    Posts
    16

    Re: Count cells that are a perfect multiple of adjacent cell?

    I attached the sample. Thanks for your help.

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,859

    Re: Count cells that are a perfect multiple of adjacent cell?

    D2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copied down

    Total:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    9,965

    Re: Count cells that are a perfect multiple of adjacent cell?

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  9. #9
    Registered User
    Join Date
    08-13-2018
    Location
    Edmonton, Canada
    MS-Off Ver
    13
    Posts
    16

    Re: Count cells that are a perfect multiple of adjacent cell?

    Thanks so much for your help.

  10. #10
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    9,965

    Re: Count cells that are a perfect multiple of adjacent cell?

    You're welcome. Thanks for the feedback and marking your thread Solved.

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,859

    Re: Count cells that are a perfect multiple of adjacent cell?

    You're welcome.

+ 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