How to count colour and content of fields?
 

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

How to count colour and content of fields?
 

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.