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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top