+ Reply to Thread
Results 1 to 2 of 2

Return one of 2 sums based on a cell value

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2016 & 365
    Posts
    49

    Return one of 2 sums based on a cell value

    Hello,

    I am trying to generate a cell value (D120) from data in my worksheet based on the value of a calculated cell on another worksheet ('Lists, formulas, and values'!G2). If it is <20, I want the value to be calculated as - =sum(D40:D44,D45,D47,D48,D49,D50,D55,D56,D57,D58,D61,D62,D63)/17. If it is 20 or greater, I want it to be calculated as - =-sum(D40:D44,D45,D47,D48,D49,D55,D56,D57,D58,D61,D62,D63)/16 - ( I just took at D50).

    Thanks for your help
    Attached Files Attached Files
    Last edited by arsenalmom; 07-13-2021 at 03:18 PM. Reason: Did not attach sample worksheet

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Return one of 2 sums based on a cell value

    Please see yellow banner on how to post a sample workbook.

+ 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] Return sums from multiple columns with criteria
    By tariqjahangir in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-23-2021, 05:26 AM
  2. Replies: 5
    Last Post: 09-08-2017, 03:51 AM
  3. [SOLVED] IF statement of 2 Sums Based on a Cell Value
    By whiterosetools in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-14-2014, 12:29 AM
  4. [SOLVED] add two sums and return blank cell when sum value totals zero
    By AMD1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 03:06 PM
  5. Calculate multiple cells sums based upon another cell
    By swiftworks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2013, 11:44 AM
  6. Add sums based on a cell being filled...
    By arizero in forum Excel General
    Replies: 6
    Last Post: 02-09-2011, 10:10 PM
  7. Replies: 10
    Last Post: 12-25-2009, 08:10 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