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

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

On Fri, 19 Feb 2010 07:31:03 -0800, LiAD
wrote:

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

On Feb 19, 4:31*pm, LiAD wrote:
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

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" wrote:

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

On Fri, 19 Feb 2010 07:31:03 -0800, LiAD
wrote:

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

.

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

On Mon, 22 Feb 2010 00:44:01 -0800, LiAD
wrote:

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" wrote:

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

On Fri, 19 Feb 2010 07:31:03 -0800, LiAD
wrote:

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

.