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

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.