+ Reply to Thread
Results 1 to 5 of 5

Excluding or Including numbers in totals

  1. #1
    Registered User
    Join Date
    07-24-2020
    Location
    Surrey, UK
    MS-Off Ver
    2019
    Posts
    3

    Excluding or Including numbers in totals

    Hello Everyone,

    I hope you can point me in the right direction here, my understanding of Excel is very basic so I don't really even no how to research what I am after.

    Problem.

    I have a workbook which for the most part consists of simple adding up of numbers. On one worksheet I have some fixed figures, that I'd like to have the option of excluding from the total, I could just delete the figure, but they need to be there as a reference, I'd like to be able to experiment with different budgets by excluding and see the end result in the Gross Profit total.

    I was using a formula like this =IF(D5="Y",0,E5) This then reads the figure in E5 and includes it in the totals column.

    It comes undone when you attempt to calculate the totals column and then take that total away from a known sum - the Gross Profit. I can't find a way of producing a gross profit minus only included figures, of if I do, I end up with tangential results depending on the conditions of previous cell Totals.

    I won't over detail the problem unless you need me to, my intuition is this must be a fairly well known and simple process, that perhaps I just need to read the right page on. Logic like this is not my strong point its probably insanely easy!

    Many thanks,
    Jon

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    43,935

    Re: Excluding or Including numbers in totals

    Welcome to the forum.

    You need to look at the SUMIFS function: https://exceljet.net/excel-functions...umifs-function

    Give us a shout if you can't get it to work for you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    07-24-2020
    Location
    Surrey, UK
    MS-Off Ver
    2019
    Posts
    3

    Re: Excluding or Including numbers in totals

    Thanks Ali, will check it out now

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    43,935

    Re: Excluding or Including numbers in totals

    Let us know how you get on.

  5. #5
    Registered User
    Join Date
    07-24-2020
    Location
    Surrey, UK
    MS-Off Ver
    2019
    Posts
    3

    Re: Excluding or Including numbers in totals

    Yep, worked a treat, thanks again.

+ 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. Returning next day (including weekends but excluding holidays)
    By cathyfirst in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 07-26-2019, 12:32 PM
  2. [SOLVED] Excluding fields and including totals from pivot chart
    By benalt613 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-24-2018, 12:40 PM
  3. [SOLVED] Countif Excluding and including parameters
    By thilag in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2015, 03:44 AM
  4. Replies: 21
    Last Post: 11-10-2014, 12:15 AM
  5. [SOLVED] Formula for Last 30 Days Excluding Saturday, but including Sunday
    By AlphaSkidz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2013, 02:23 PM
  6. List Dates Excluding Holidays but Including weekends
    By GuyHudson in forum Excel General
    Replies: 6
    Last Post: 09-22-2010, 05:58 AM
  7. Workday function including sat, excluding sun
    By Handyy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2006, 02:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1