+ Reply to Thread
Results 1 to 11 of 11

Count cells that are a perfect multiple of adjacent cell?

  1. 01-11-2019, 06:20 PM #1
    Jango Fett
    Jango Fett is offline
    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.
    Reply With QuoteRegister To Reply
  2. 01-11-2019, 06:25 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    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 - Retired Excel/VBA Consultant

    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

    Reply With QuoteRegister To Reply
  3. 01-11-2019, 06:54 PM #3
    Jango Fett
    Jango Fett is offline
    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?
    Reply With QuoteRegister To Reply
  4. 01-11-2019, 06:56 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    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.
    Reply With QuoteRegister To Reply
  5. 01-11-2019, 07:02 PM #5
    Jango Fett
    Jango Fett is offline
    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
    Reply With QuoteRegister To Reply
  6. 01-11-2019, 07:02 PM #6
    Jango Fett
    Jango Fett is offline
    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.
    Reply With QuoteRegister To Reply
  7. 01-11-2019, 07:35 PM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    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.
    Reply With QuoteRegister To Reply
  8. 01-12-2019, 09:10 PM #8
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    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
    Reply With QuoteRegister To Reply
  9. 01-14-2019, 02:01 PM #9
    Jango Fett
    Jango Fett is offline
    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.
    Reply With QuoteRegister To Reply
  10. 01-14-2019, 02:06 PM #10
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

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

    You're welcome. Thanks for the feedback and marking your thread Solved.
    Reply With QuoteRegister To Reply
  11. 01-14-2019, 02:25 PM #11
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

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

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need perfect RESULT of two cells in another cell with if function
    By vijubhau in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-05-2018, 12:31 AM
  2. Fornula needed: Count cells is adjacent cell contains or equals to specific word
    By tatiana4eva in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-30-2014, 09:10 AM
  3. [SOLVED] count number of cells in Column C that have a lesser or equal value to the adjacent cell
    By Geoff Jones in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-18-2013, 11:01 AM
  4. Count Blank Cells which Today falls within a Date Range based on Adjacent cell
    By CamDoll in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2013, 11:32 PM
  5. [SOLVED] Count how often value occurs in multiple groups with non adjacent cells.
    By swmwshrk in forum Excel General
    Replies: 2
    Last Post: 07-09-2012, 09:21 PM
  6. How do i count cells where the adjacent cell is of certain string value?
    By timatrix17 in forum Excel General
    Replies: 4
    Last Post: 01-13-2012, 07:39 AM
  7. sum non adjacent cells with multiple count criteria
    By icylemontea in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-20-2011, 04:13 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1