Hi Low,

Unfortunately, Excel 2007 does not have the ability to use color as a condition in the SUMIF() function. However, there are a few workarounds that you can use to achieve the same result.

Option 1:

1. Use a helper column where you manually enter a value or text to indicate the color of the cell. For example, you could use "Red" for cells with red font color and "Green" for cells with green font color.
2. Then, you can use the SUMIF() function to sum up the values based on the helper column.

Option 2:

1. Use a macro to automate the process.
2. You can write a VBA code that loops through the cells and checks their font color or background color, and then adds up the values accordingly.

Let me know if you need any further assistance.