• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

Forum home » Delegate support and help forum » » 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 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 courses

Training information:

 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 What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips