Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
add total only shaded cells
Hi everybody,
Can anyone help. I have a formula that colors the cell which is less, how can I add only the colored cells? Example; Collumn "A" & Collumn "B" with 100 rows each, entered a formula to highlight with a color the <cell. Is there a way to add the value of the colored cell only? Please help! -- smile |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
add total only shaded cells
On 2 Dec., 19:46, israel wrote:
Hi You can not sum by color, but you can use a sumif formula, and apply the you used to color cells Your formula could look like this: =SUMIF(A1:B100,"<100") Regards, Per Hi everybody, Can anyone help. * I have a formula that colors the cell which is less, how can I add only the colored cells? Example; Collumn "A" & Collumn "B" with 100 rows each, *entered a formula to highlight with a color the <cell. *Is there a way to add the value of the colored cell only? Please help! -- smile |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
add total only shaded cells
Try this:
=SUMPRODUCT(((A1:A100<B1:B100)*A1:A100)+((B1:B100< A1:A100)*B1:B100)) -- Biff Microsoft Excel MVP "israel" wrote in message ... Hi everybody, Can anyone help. I have a formula that colors the cell which is less, how can I add only the colored cells? Example; Collumn "A" & Collumn "B" with 100 rows each, entered a formula to highlight with a color the <cell. Is there a way to add the value of the colored cell only? Please help! -- smile |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shaded cells won't print shaded | Excel Worksheet Functions | |||
How do I get gridlines in shaded cells? | Excel Discussion (Misc queries) | |||
linking shaded cells | Excel Discussion (Misc queries) | |||
How do I count shaded cells | Excel Worksheet Functions | |||
Selecting shaded cells in a row | Excel Worksheet Functions |