+ Reply to Thread
Results 1 to 7 of 7

please help, problems with how to simplify the IF functions

  1. #1
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    please help, problems with how to simplify the IF functions

    hi,

    I have a problem with the function of if and how to summarize thus saving time

    thanks in advance
    Attached Files Attached Files
    Last edited by herukuncahyono; 04-12-2013 at 12:39 AM.

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: please help, problems with how to simplify the IF functions

    IF function problem.xls <---Please find attached file
    Can use SUMIF();

    Hope it help!
    Last edited by wenqq3; 04-12-2013 at 12:29 AM.
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: please help, problems with how to simplify the IF functions

    In M3 cell
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag it down and right...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Re: please help, problems with how to simplify the IF functions

    Hi wenqq3
    Thanks... for your help....

    terimakasih


    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: please help, problems with how to simplify the IF functions

    Quote Originally Posted by :) Sixthsense :) View Post
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    .
    Your formula do better

  6. #6
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Re: please help, problems with how to simplify the IF functions

    hi Sixthsense ...
    the formula works well..

    thanks...

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: please help, problems with how to simplify the IF functions

    Quote Originally Posted by wenqq3 View Post
    Your formula do better
    No not like that, in this situation sumif (Your Suggestion) is better than sumproduct

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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