98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel-xp-training - Excel 2007 - Addition of formatted cells
excel-xp-training - Excel 2007 - Addition of formatted cells
Resolved · Low Priority · Version Standard
Katie has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Excel 2007 - Addition of formatted cells
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.
RE: Excel 2007 - Addition of formatted cells
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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:No ZerosWant all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK. |