Hi,

I have 12 columns with my monthly expenses.
If the expense is paid, I change the color to e.g. Green.
I want row 2 on top of EACH month-column to show the sum of non-green
cells in that column.

How to handle this efficiently???

Thanks for any help.

Take a look he

http://cpearson.com/excel/colors.htm


In article .com,
"Paulus" wrote:

I have 12 columns with my monthly expenses.
If the expense is paid, I change the color to e.g. Green.
I want row 2 on top of EACH month-column to show the sum of non-green
cells in that column.

Hello,
Looks good, but I have a newbie problem:
The cell where i put the formula shows : #NAAM?
In English this would be #NAME?

It seems it cannot find the function?
Thx for any additional help

Paul


JE McGimpsey wrote:
Take a look he

http://cpearson.com/excel/colors.htm


In article .com,
"Paulus" wrote:

I have 12 columns with my monthly expenses.
If the expense is paid, I change the color to e.g. Green.
I want row 2 on top of EACH month-column to show the sum of
non-green
cells in that column.

thx, got it now. This newbie only had to figure out that I need to make
a module. :-)