View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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