+ Reply to Thread
Results 1 to 2 of 2

IF Formula

  1. #1
    Registered User
    Join Date

    IF Formula

    I need help!

    I have a worksheet with 100 entries on it each entry is a transaction. One column indicates if the transaction is closed or not (Yes or No). I need to write a formula that will allow me to add up the transaction amounts depending on if the transaction is closed (YES). I was thinking that I could use IF but cannot figure out how to use it for the entire worksheet.

    Any help is GREATLY appreciated.

  2. #2
    Forum Contributor
    Join Date
    Use the sumif() function. It allows you to specify what to sum and the condition to use - "yes" in the column you are using. It should be exactly what you need.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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