+ Reply to Thread
Results 1 to 2 of 2

Google Sheets: Display Grand Total only when a column have value greater than 0

  1. #1
    Registered User
    Join Date
    08-29-2022
    Location
    pakistan
    MS-Off Ver
    2016
    Posts
    1

    Google Sheets: Display Grand Total only when a column have value greater than 0

    I have DEALER MAP Quantity columns in Google Sheets On the MAP column I am having my Grand total which is the SUM of my MAP column. The Quantity column is having 0s which means there is no Product selected.

    I want to show the Grand Total as 0 under MAP but Not 0 when any number more than 0 is added into Quantity.

    The 10% is the row for finding TAX.The fomulas are here for
    TAX =(D3E3+D5E5+D6E6+D7E7+D8E8+D9E9+D10E10+D11E11+D12E12+D13E13+D14E14+D15E15)*D20

    For The Grand Total =SUM(D3:D15,E20)
    1231.PNG
    Last edited by rohyl; 08-29-2022 at 02:37 AM.

  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,779

    Re: Google Sheets: Display Grand Total only when a column have value greater than 0

    Welcome to the forum.

    Google Sheets is NOT Excel, so I've moved this thread.
    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.

+ 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] Google Sheets: If 2 criteria are met, display value from next column on other sheet
    By Gavin101 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 13
    Last Post: 08-04-2021, 05:13 PM
  2. [SOLVED] how to do multi column comparison and display matches and differences with google sheets
    By tkalinoski in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 03-04-2021, 09:22 AM
  3. display sub totals for each Agency and grand total
    By excelrequired in forum Excel General
    Replies: 5
    Last Post: 02-08-2020, 09:32 PM
  4. Need help creating pivot - grand total and grand total as % of column value
    By obionenairobi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-18-2017, 08:00 AM
  5. Replies: 6
    Last Post: 09-29-2015, 08:44 PM
  6. formula calculates ratio for Grand Total, not Sub Total for each column
    By vkievsky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2013, 11:26 AM
  7. Pivot table - not to display 0 in grand total
    By Harrold in forum Excel General
    Replies: 4
    Last Post: 06-24-2011, 08:58 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