Summing only coloured cells

  • Thread starter Thread starter maxmil
  • Start date Start date
M

maxmil

Hi,

I need to make a sum of some values in a column, but only of those that
have been highlighted in yellow.
Maybe the answer is simple, can you please help me put the colour of a
cell in a formula as a parameter and thus sum only coloured cells?

Thanks in advance
Regards
Max
 
Hi maxmil,
I need to make a sum of some values in a column, but only of those
that have been highlighted in yellow.
Click to expand...

do NOT highlight with yellow. Have an extra column where users should
type "x" or whatever if they want to highlight. Then you an use
conditional formats to highlight with yellow and you can use eg. sumif,
filters etc. based on the colum with "x".

arno
 
Back
Top