+ Reply to Thread
Results 1 to 3 of 3

Need formula to calculate value in multiple column divided by value in other cell (date )

  1. #1
    Registered User
    Join Date
    01-11-2024
    Location
    Canada
    MS-Off Ver
    365
    Posts
    4

    Exclamation Need formula to calculate value in multiple column divided by value in other cell (date )

    Hey, need your help.

    Trying to find an easy way to calculate Average CS sold per month based on total of column C to N (per line) divided by number of days represented by date entered in cell P4.

    Formula in Cell O for each line is SUM of C to N.
    I need formula in Cell P to take the total in Cell O divided by date entered in Cell P when I update my report.

    I currently pull my sales report every two weeks and I manually change the formula in Cell P for each line to =+O6/1 (for example now for Jan). But if I pull my sale report lets say on Feb 15th, I would manually change the formula to =+O6/2.5.

    Is there an easier way to calculate this based on the date I populate in cell P4?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,958

    Re: Need formula to calculate value in multiple column divided by value in other cell (dat

    I would put 1/1/2024 into cell P3, and then use this in P6:

    =O6/MROUND((($P$4-$P$3)/30),0.5)

    copied down.

    Note that your 'middle of February' logic of dividing by 2.5 (=+O6/2.5) really should be =+O6/1.5 since the middle of February is 1 1/2 months into the year.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    01-11-2024
    Location
    Canada
    MS-Off Ver
    365
    Posts
    4

    Smile Re: Need formula to calculate value in multiple column divided by value in other cell (dat

    Thank you for the formula and correcting the logic of ''middle of February'' for my calculation.
    Greatly appreciated!

+ 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. [SOLVED] Formula to calculate the next available date in a column
    By jclaborn in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-16-2020, 01:37 PM
  2. Replies: 1
    Last Post: 12-18-2018, 04:23 PM
  3. Replies: 6
    Last Post: 12-07-2016, 02:36 AM
  4. Replies: 6
    Last Post: 12-07-2016, 12:28 AM
  5. Replies: 1
    Last Post: 12-06-2016, 06:28 PM
  6. [SOLVED] How do I calculate today's date divided by a number?
    By excelrookie321 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2015, 08:43 PM
  7. Replies: 17
    Last Post: 12-05-2012, 11:36 AM

Tags for this Thread

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