Sum if cell = grey

[LiAD]

Hi,

Is it possible to have sum if cell = a colour?

If for example from row A1 to 20 I have a list of numbers each with or
without a cell fill colour as required. Is there a formula, (not code), I
can use to calculate the sum of all the cells coloured in grey for example
(colour index 15)?

Thanks
LiAD

 

[Gord Dibben]

How did the cells get to be colored?

Manually..........you will need code.

Conditional Formatting?

SUMIF or SUMPRODUCT by same criteria.


Gord Dibben MS Excel MVP

 

[Michael.Tarnowski]

Hi,

Is it possible to have sum if cell = a colour?

If for example from row A1 to 20 I have a list of numbers each with or
without a cell fill colour as required.  Is there a formula, (not code), I
can use to calculate the sum of all the cells coloured in grey for example
(colour index 15)?

Thanks
LiAD

Hi LiAD,
you find Excel Functions/Formulas to Count/Sum Excel Cells by Color on
oxgrid's site:
http://www.ozgrid.com/VBA/Sum.htm

HTH, have a nice day
Cheers Michael

 

[LiAD]

Hi,

Thanks for your help

The cells were manually coloured. However In order to avoid using code I
could put a T at the end of the number then use cond. format to colour it.
This would generate a list of numbers such as -: 3 5T 9562 65237T
0.9T 54….whatever. What is the simplest function I can use to sum if the
number contains T?

Thanks

Thanks

 

[Gord Dibben]

If you're going to adding a "T" don't add it to the numbers.

Add it in adjacent cells in a helper column then filter on the that column
for "T" and use

=SUBTOTAL(9,A1:A20)


Gord