Sum by Text Color 1

[GSCaupling]

Excel 2007; Windows 7

I searched for this and the answers seemed to apply to Excel 2003, so here goes again.

I have a spreadsheet that tracks payables by week. The absolute easiest way for me to indicate that an item (there are perhaps 50 per week) has been paid is to change the text or fill color.

Will SUMIF work on such color changes? Is there another solution?

Thanks,
GS

[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]

 

[Gruuuu]

Sumif will not work with cell colors. It would be nifty if so.

Would it be too much of a change to use check boxes linked to cells in another column on the same row as the account?

Example:

[tt]
Account Amount Paid
account 1 $100.00 False ( )
account 2 $50.00 True (x)
account 3 $200.00 True (x)
_______________________________________
Total Paid $250.00
[/tt]

You can even use Conditional Formatting to color the cells yellow based on your Paid column

 

[GSCaupling]

Gruuuu,

Thanks for the quick response.

Your solution is perfect. Mostly I wanted to avoid two columns per week for dollar amounts - one due, one paid - where I had to move amounts from one column to the other as they were paid. Plus, looking at twice as many dollar figures would be visually confusing.

Thank you again!
GS

[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]

 

[Gruuuu]

Glad I could help