Thanks Niek for your very swift answer.

Unfortunately I am quite uncertain about formulae and although I have looked
at this page, I am still baffled.

I have put the formulae =SUMPRODUCT(--(ColorIndex(A1:A100)=3)) into a cell
but I just get the #NAME? error.

I presume I am doing something wrong but not sure what.

Sorry if I am being a little dim!

"Niek Otten" wrote:

Look he

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"hollies" wrote in message ...
| Hello
|
| I can't seem to find if this can actually be done but, using Excel 2003, I
| have a worksheet with several blocks containing cells numbered from 1 to 100.
|
| From these blocks, I want to be able to count each cell as a value of 1 if I
| change the background colour to red (or any other colour) then multiply that
| value by a number, say 5.
|
| eg If I select the first 25 cells and fill them red, I want my "total" Cell
| to show the sum of 25 * 1 * 5 giving me 125.
|
| Hope this is understandable!
|
| Thanks for any help.
|
|