+ Reply to Thread
Results 1 to 2 of 2

Help in Formula using 'if'

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help in Formula using 'if'

    Query.jpg

    Image Location: -
    http://s9.postimg.org/a6q2hmdv3/Query.jpg

    Here i want to put a Formula in 'G' column field where 7100 appears.

    At the moment i am myself calculating 1100 + 1000 + 5000 and adding and writing 7100 in the G column. I want a Formula where Numbers in column 'E' are only added if column 'D' has something written in front of it for e.g: - 10 or 11, or 12, 555 , 666 & so on...... If nothing is written in column 'D' like for e.g:- next to 4000 then this 4000 should not be added to 7100 and likewise the last 'E' field 1000 also will not be added as nothing in written in column 'D' against it.

    Requesting for help in coming up with such a formula.
    Note- This Image is for representation. Column 'D', 'E' has around 100 rows

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Help in Formula using 'if'

    Try
    =SUMIF($D$6:$D$200,"<>",$E$6:$E$200)
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

+ 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. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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