Results 1 to 4 of 4

Sumif Function

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2017
    Location
    Phoenix AZ
    MS-Off Ver
    16
    Posts
    21

    Sumif Function

    Trying to solve an issue with the following scenario:

    Cells A1-A4 Sum into Cell A5

    and Cell A6 has a value in it (Such as 100)

    Then the result of the logic to be as such:

    If Cell A5 is Not Zero, then take the value of cell A6-A5 and sum into A7
    If Cell A5 is Zero, and A6 has the same value (100) place a Zero into A7

    A1 10
    A2 5
    A3 0
    A4 5
    A5 20
    A6 100
    A7 80

    or

    A1 0
    A2 0
    A3 0
    A4 0
    A5 0
    A6 100
    A7 0

    TIA
    Attached Files Attached Files
    Last edited by tcash33; 11-21-2019 at 01:34 PM. Reason: spelling

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to lock or freeze today funtion and Now funtion
    By edwest01 in forum Excel General
    Replies: 2
    Last Post: 12-09-2018, 06:35 PM
  2. issue ith SUMIF funtion
    By Hisham Diab in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-04-2015, 03:16 AM
  3. SUMIF / SUMPRODUCT Funtion
    By akkerstad in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-26-2015, 01:34 PM
  4. [SOLVED] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2014, 09:25 PM
  5. Dynamic shifting range for SUMIF funtion
    By irishkingkong in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2013, 05:20 AM
  6. [SOLVED] Autofilling SUMIF funtion
    By inheaven in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2013, 10:52 PM
  7. Funtion Help
    By snu2216 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-21-2011, 01:38 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1