Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-xp-training - Excel 2007 - Addition of formatted cells
|
|
|
The UK's most regular 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-xp-training - Excel 2007 - Addition of formatted cells
Resolved · Low Priority · Version Standard
Reply Tue 16 Oct 2007, 14:37Delegate Katie said...
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.
For upcoming training course dates see: Pricing & availability
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.
|