excel-xp-training - excel addition

Forum 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

resolvedResolved · 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.


 

Excel tip:

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


Server loaded in 0.07 secs.