IF-THEN Statements help

**KaisaUbun2** · 11-18-2012, 04:49 PM

I have a workbook that I use for personal financing I have multiple worksheets, one of my work sheets it bills and the other is DATA.

In one of the columns it says OUTSTANDING BALANCE, and in the Second Column it says STATUS. If status is PAID then the row turns green. Now I want to calculate total PAID balance.
So I tried to create and if, then statement like this. =SUMIF(STATUS,PAID,OUTSBAL) (This is what I named the ranges) however it doesn't add the values in the OUTSBAL column, when the status is paid. Is it because I am using a phrase? would it work if I had it with numbers like 1,0??? I hope this isn't too confusing if it is I can do screen shots

**Steve N.** · 11-18-2012, 04:52 PM

How about a sample of the workbook? Let's see what your working with...

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.