Hi, after i have formatted cells, how do then add up only some of the proceeds... i.e. if i have inserted a formula to turn them yellow... how do i only add the yellow cells?

thank you.

not sure if thast approach is the best way to do it, as excel can add by value, not by format.


You could use similar criteria that you used to format the cells yellow (conditional formatting), in a FUNCTION called SUMIF.

This allows you to add together cells that meet specific criteria.




SUMIF(range,criteria,sum_range)

Range
is the range of cells that you want evaluated by criteria.

Criteria
is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, "32", ">32", or "apples".

Sum_range
are the actual cells to add if their corresponding cells in range match criteria. If sum_range is omitted, the cells in range are both evaluated by criteria and added if they match criteria.