+ Reply to Thread
Results 1 to 4 of 4

Help with formula for totals greater than sum

  1. 11-07-2017, 03:49 PM #1
    Lagina
    Lagina is offline
    Registered User
    Join Date
    11-06-2017
    Location
    Sandy Hook, KY
    MS-Off Ver
    2010
    Posts
    9

    Help with formula for totals greater than sum

    I need help writing a formula for the sum of a column that is greater than 346 to be rounded down to 346.

    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 11-07-2017, 03:51 PM #2
    Pete_UK
    Pete_UK is online now
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,794

    Re: Help with formula for totals greater than sum

    You can use this approach:

    =MIN(346, your_SUM_formula)

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 11-07-2017, 03:55 PM #3
    Zer0Cool
    Zer0Cool is offline
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Help with formula for totals greater than sum

    You may also consider ROUNDDOWN, ROUND, TRUNC
    Reply With QuoteRegister To Reply
  4. 11-07-2017, 04:13 PM #4
    Lagina
    Lagina is offline
    Registered User
    Join Date
    11-06-2017
    Location
    Sandy Hook, KY
    MS-Off Ver
    2010
    Posts
    9

    Re: Help with formula for totals greater than sum

    Thanks guys! That worked!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table Percentage of grand totals listed under the grant totals
    By Biker102 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-31-2017, 01:31 PM
  2. [SOLVED] Cell Refrencing multiple sheet totals to a totals page
    By 007Buff in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-08-2015, 02:23 PM
  3. [SOLVED] find value which is greater than in a range of cells and return the greater value
    By green369 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2015, 02:46 AM
  4. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  5. [SOLVED] How do I group daily totals into weekly/monthly/quarterly totals
    By situationroom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 09:58 AM
  6. Calculating grand-totals using numerous sub-totals in seperate coloumns.
    By londonp in forum Excel General
    Replies: 4
    Last Post: 01-10-2008, 12:31 PM
  7. Reversing POWER Formula:with greater algebra skills help me with below formula?
    By [email protected] in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-01-2005, 07:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1