Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif depending on format
Hi,
I would like to sum the cells in one column that have a differente format from the others (red background, say). How do I use the "sumif" fonction but with formats i. o. values? Many thanks in advance. Luis |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif depending on format
Generally, you won't be able to do that.
However, if that red background is applied through conditional formatting, then you could have a formula which makes use of that condition and counts (or sums) accordingly. If this is the case, then give us some details about your sheet(s). Hope this helps. Pete On Dec 23, 9:43*am, luiss wrote: Hi, I would like to sum the cells in one column that have a differente format from the others (red background, say). How do I use the "sumif" fonction but with formats i. o. values? Many thanks in advance. Luis |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif depending on format
Hi Luis - check out this link here for sum and count based on the fill
colour of a cell... http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm Muppet Man. On Dec 23, 9:43*am, luiss wrote: Hi, I would like to sum the cells in one column that have a differente format from the others (red background, say). How do I use the "sumif" fonction but with formats i. o. values? Many thanks in advance. Luis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF CSE Formula that sums multiple columns depending on IFstatement | Excel Worksheet Functions | |||
Code Date Format Depending on Computer format | Excel Discussion (Misc queries) | |||
sumif depending on 2 cells matching | Excel Worksheet Functions | |||
Condtional format of row depending on string value of $A2 + | Excel Discussion (Misc queries) | |||
How do I format a row depending on the value of a cell in the row | Excel Discussion (Misc queries) |