+ Reply to Thread
Results 1 to 5 of 5

Cells auto-divide evenly

  1. #1
    Registered User
    Join Date
    11-28-2020
    Location
    Georgia, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    2

    Cells auto-divide evenly

    On the Worksheet 'Total Job Cost':
    I'm trying to figure out a formula for B19:B29, so that if there is a name chosen in any of the cells E19:E29, then the cells B19:B29 automatically divide the number in cell C3 by how many names have been chosen in cells E19:E29. To be clear, I don't want a quotient in corresponding cells that don't have a name. So, if there's a name in E19 (and no other names in the cells E20:E29), then B19 will auto-divide the number in cell C3 by "1". If there are names in E19, E20, & E21 (and no other names in E22:E29), then B19, B20 & B21 will auto-divide cell C3 by "3".

    Thanks for any help!!
    Attached Files Attached Files
    Last edited by AlexWhite532; 11-29-2020 at 06:38 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Cells auto-divide evenly

    Try, in B19, copied down

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Cells auto-divide evenly

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


    And copy to cells B19:B29

    Cheers

  4. #4
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Cells auto-divide evenly

    Woops should be B19:B29 not E19:E29

  5. #5
    Registered User
    Join Date
    11-28-2020
    Location
    Georgia, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    2

    Re: Cells auto-divide evenly

    Hey!! Awesome! It seems to work! Thanks! This's actually kinda similar to a formula I already tried, except I didn't use 'ISBLANK', and I used 'COUNT' instead of 'COUNTA'.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Divide a range evenly across cells given min and max
    By pambree in forum Excel General
    Replies: 4
    Last Post: 01-14-2024, 01:42 AM
  2. Replies: 0
    Last Post: 09-05-2012, 12:09 AM
  3. How do I divide the work evenly between teammates
    By Godiva in forum Excel General
    Replies: 4
    Last Post: 07-22-2012, 09:27 AM
  4. Replies: 7
    Last Post: 07-10-2012, 02:33 AM
  5. divide rows evenly into columns
    By dwrkz in forum Excel General
    Replies: 2
    Last Post: 07-01-2009, 10:34 AM
  6. [SOLVED] DIVIDE NUMBERS EVENLY
    By NEYS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2006, 03:48 AM
  7. [SOLVED] Divide numbers and distribute evenly.
    By rhon101 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-16-2006, 09:50 PM

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