Sum cells based on cell format

[craigexcel]

In 1 of the columns in my worksheet, I enter only 1 of 2 possible payment values. Once a payment is made, I format that number as bold. Is it possible to build a formula that will sum a range of cells based on their (bold) format, and likewise, sum those payment values that are not bold?

Or can you suggest an alternative way to accomplish this, i.e. another way to indicate the 'paid' status? Thanks.

 

[Oaktree]

There is no embedded way to sum only bold numbers. You'd have to make a UDF (user defined function) in VBA.

Instead, why not use a third column for the actual payment and just sum that column?