I have searched the site but CANT seem to find any IF statement that could do what I am wanting. Not even sure if an IF statement is what I need to be using.

I am CREATING an accounts spreadsheet and have each month in a separate workbook. I have created a drop down list of 8 reasons for money to move in or out. next to this will be the amount then a comment.

The problem I have is that I want there to be a total in and out for each of the 8 reasons, and also a total in and out for them all and red for a loss and black for a profit. I could colour them after but this sheet will be distributed to other users to fill in. Is this something that can be done? I have made it sound a lot harder than it needs to be

please CONTACT me for any more info

Thanks

IanWhat version of Excel are you using? The Subtotals function comes to mind as possible technique that might serve your purpose. A REFERENCE: http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=358 As for coloring the numbers in a cell, look at conditional formating. You can set the font, or the background, to be red if the condition is <0. You could also make the font Bold and/or change it's size. There are many more things conditional formating will do.