Simple Excel Formula

Hi Dan

Thanks for uploading the spreadsheet, it makes it easier to see what you want to do.

I've created a formula to help with your calculation and have also added some suggested improvements to your original layout and formulas for some of the other cells:

1. Conditional formatting to automatically highlight if the Paid is Y (green) or N (red).
   
   
2. Total Bills paid now sums any amounts that are Y.
   =SUMIF(D3:D14,"Y",C3:C14)
   
   
3. Added a Total remainder owing cell (C17) to show what is still unpaid/owing.
   =SUMIF(D3:D14,"N",C3:C14)
   
   
4. Put a new formula in the Total (C21) cell to calculate you Income minus Total Owning to give you a final Total.
   =SUM(C19:C20)-C17
   
   
5. Have applied conditional formatting the final Total cell (C21) to show green if your income is more than your outstanding balance, or red if you owe more money than you have.
   
   
6. Moved Paid column next to column C (Amount) for easy viewing.

Everything attached in your modified file is an optional extra. Was just having a bit of fun on this Friday afternoon!

I hope something in the attached helps. Let us know how you go?

Cheers

Damien