Sumif depending on format

L

luiss

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
 
P

Pete_UK

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
 
Top