Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shaded cells won't print shaded | Excel Worksheet Functions | |||
Error handling VLOOKUP. #N/A - can it be 0 to allow sumation. | Excel Worksheet Functions | |||
Sumation | Excel Discussion (Misc queries) | |||
returning either a shaded cell &/or a text | Excel Discussion (Misc queries) | |||
How am i able to populate a sumation for multiple sheets | Excel Worksheet Functions |