Hi all,

I was hoping that someody may be able to assist me in this area which I've no experience of doing before. I have a spreadsheet containing a colour coded column, with each field containing text also.

I need 2 results at the bottom of this, preferably auto-calculating each time the contents of those fields are updated.

I need one area which denotes how many red/green/amber fields there are for example.

Then for the same fields, I also need a count of how many say "SAC1/SAC2/SAC3" etc. I have attached a copy of the file.

Any help would be greatly appreciated as I've no idea how to begin this.

Thanks
Dawn

On Tuesday, June 19, 2012 5:53:22 AM UTC-5, D4WNO wrote:
Hi all,

I was hoping that someody may be able to assist me in this area which
I've no experience of doing before. I have a spreadsheet containing a
colour coded column, with each field containing text also.

I need 2 results at the bottom of this, preferably auto-calculating each
time the contents of those fields are updated.

I need one area which denotes how many red/green/amber fields there are
for example.

Then for the same fields, I also need a count of how many say
"SAC1/SAC2/SAC3" etc. I have attached a copy of the file.

Any help would be greatly appreciated as I've no idea how to begin
this.

Thanks
Dawn


+-------------------------------------------------------------------+
|Filename: Copy of Scope of Service MASTER TEST.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=430|
+-------------------------------------------------------------------+



--
D4WNO

By what method did the cells become colored.