Closed Thread
Results 1 to 6 of 6

Working back mathematical calculation

  1. #1
    Registered User
    Join Date
    08-18-2019
    Location
    Cape Town
    MS-Off Ver
    2019 (O365)
    Posts
    16

    Talking Working back mathematical calculation

    Hi everyone

    I'm building further on this and need another round of assistance to calculate subtotal values, but only if certain conditions are met. (Im assuming IF/Vlookup?)

    attached example will better explain (I hope and trust) and the outcome should be the total of all "once-off" items (added together if it overlaps with another).
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,870

    Re: Working back mathematical calculation

    This is just a follow-on from your earlier thread, isn't it?

    NO HELP TO BE OFFERED YET, please.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,731

    Re: Working back mathematical calculation

    Quote Originally Posted by AliGW View Post
    ...NO HELP TO BE OFFERED YET, please ...
    Well, it didn't make much sense to me when I first read it anyway.

    Pete

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,870

    Re: Working back mathematical calculation

    I'm likely to close this and unsolve the original - I don't think it warrants a new thread, but I need a response from the OP first.

  5. #5
    Registered User
    Join Date
    08-18-2019
    Location
    Cape Town
    MS-Off Ver
    2019 (O365)
    Posts
    16

    Re: Working back mathematical calculation

    Hi AliGW

    Being new to this, Im not sure what I am doing wrong - please guide me so I can do it correctly?

    Yes, it is a follow up on earlier post.

    Ill await your guidence if I am using this forum incorrectly - apologies.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,870

    Re: Working back mathematical calculation

    Administrative Note:

    It would be easier to keep everything under one roof.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ider-zero.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 07-02-2021, 01:58 AM
  2. [SOLVED] Price Calculation - mathematical formula
    By Ademske in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-07-2018, 02:07 PM
  3. Mathematical Function not working
    By FranktheBank in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-06-2016, 11:20 AM
  4. mathematical and calculation formula for angles
    By maestro_uk in forum Excel General
    Replies: 6
    Last Post: 08-09-2014, 07:22 PM
  5. [SOLVED] Turned Off Calculation; Cannot Turn Calculation It Back On Again
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2014, 05:28 PM
  6. Replies: 3
    Last Post: 03-05-2013, 03:42 PM
  7. How do I enter a working mathematical formula?
    By ianpwilliams in forum Excel General
    Replies: 4
    Last Post: 12-09-2011, 08:56 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