How set totals of various cells with per colour fill value?

A

AA Arens

I have a sheet containing values as follows.


April May June
company 1 43
company 2 5
company 3 17


The cell values are also coured to indice a status.
Somewhere beside the table I want to mention the totals of the cells,
per status (so per colour).
How to perform the latter?



Thank you.

Bart
Excell 2003
 
A

AA Arens

Bob, where to set the script in VB, I cannot find the macro editor in
Version 12 of Excel.

Bart
 
A

AA Arens

Bob, where to set the script in VB, I cannot find the macro editor in
Version 12 of Excel.

Bart
 
B

Bob Phillips

Goto the VBIDE (Alt-F11), add a new code module (Insert>Module)< and add it
there.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Top