craigexcel
Active Member
- Joined
- Jun 28, 2006
- Messages
- 295
- Office Version
- 2016
- Platform
- Windows
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.
Or can you suggest an alternative way to accomplish this, i.e. another way to indicate the 'paid' status? Thanks.