shaded cell sumation

O

oldLearner57

hi community

is there a possibilities that i can do a sumation on shaded cells....

example:

i had filled up a range of cells with numeric data and i shaded some cell with
color....


A B C D

1 10 20 30 40

2 30 34 45 45

3 45 45 50 45

example above, say i shaded A3 with tan color & B2 with tan color & C1 with
tan color
than
I wish to use the sum by the shaded color ...
is this possible?

thanks community for the assistance :)

thanks all
 
G

Gord Dibben

Couple of methods.

1. See Chip Pearson's site for his SumByColor function.

http://www.cpearson.com/excel/colors.aspx

2. If your version of Excel is not older than 2003 you can select(find) by
format then select these and see the SUM on the Status Bar.

Select your range and Edit>Find>Format.

Select the Tan pattern and Find All.

In the 'Found" dialog box hit SHIFT + down arrow.

Click on Status bar and select "SUM"


Gord Dibben MS Excel MVP
 
Top