+ Reply to Thread
Results 1 to 3 of 3

SUMIF and subtraction of specific cells issue...request for help :)

  1. #1
    Registered User
    Join Date
    09-10-2016
    Location
    TN
    MS-Off Ver
    2013
    Posts
    2

    SUMIF and subtraction of specific cells issue...request for help :)

    Hi everyone
    Very new to excel formulas, so i apologize in advance...I have searched online and found similar formulas but i havent tweaked them to make it do what i want....the more involved it gets the less i understand.

    situation 1:
    D12 E12 F12 G12
    250 252 2 -2

    these are pounds lost or gained (weight) so D12 is the starting weight, E12 shows a gain of 2 so i only want a number to appear in F12 if the number goes up (above 0) so F12 would reflect a 2 LB weight gain. I dont want anything to show in G12. It currently does because all i could do is have each cell set up separately to calculate D12 and E12 the way i want.

    So ideally it would look like this if the E12 cell is higher than D12: (i suppose if its easier G12 could show a 0 but i want a 0 or nothing at all if possible)
    D12 E12 F12 G12
    250 252 2

    ------------------------------------

    situation 2:
    D12 E12 F12 G12
    250 248 -2 2

    In this one I want the opposite. When the weight is lost I want to subtract E12 from D12 and the answer to only show in G12 and nothing in F12

    So when D12 cell is higher I would like it to look like this:
    D12 E12 F12 G12
    250 248 2

    i hope that makes sense and I would really appreciate any help on creating the formula to make that work....i am really not experienced in it so I can not seem to create it myself just searching online...i always have an error.

    thanks for any help!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,036

    Re: SUMIF and subtraction of specific cells issue...request for help :)

    In F12:
    =IF(E12>D12,E12-D12,"")

    In G12:
    =IF(D12>E12,D12-E12,"")
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    09-10-2016
    Location
    TN
    MS-Off Ver
    2013
    Posts
    2

    Re: SUMIF and subtraction of specific cells issue...request for help :)

    Thank you for the quick reply...will this work in open office? do they function the same for formulas? I am on a different PC for a couple days so I cant test that yet but those suggestions do not work on my openoffice version....should i be putting something in between the quotations? forgive me as my experience is minimal to nil....only what i find on the web when i search. I appreciate the help though very much!

+ 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] Criteria based Addition and Subtraction - VBA Request
    By spiwere in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-18-2015, 07:10 PM
  2. Inventory Subtraction Sum Issue
    By cathieanne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2014, 06:28 PM
  3. SUMIF subtraction with multiple conditions (OR)
    By Flash_82 in forum Excel General
    Replies: 2
    Last Post: 04-29-2014, 10:54 AM
  4. SUMIF Issue, how to not count specific values
    By Hypnopoison in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2013, 12:57 PM
  5. Stumped on a formula (combo of sumif, vlookup, subtraction?)
    By silentheidi in forum Excel General
    Replies: 1
    Last Post: 05-11-2012, 07:26 PM
  6. Replies: 3
    Last Post: 12-15-2010, 04:00 AM
  7. Subtraction macro request ...
    By rocket1406 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-13-2007, 03:10 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