shaded cell sumation
 

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

--
oldLearner57

shaded cell sumation
 

the subject is discussed here

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

Mike

"oldLearner57" wrote:

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

--
oldLearner57

shaded cell sumation
 

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 EditFindFormat.

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

On Wed, 23 Apr 2008 00:40:02 -0700, oldLearner57
wrote:

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