Calculate my expenses

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 here:

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


In article <[email protected]>,
"Paulus" <[email protected]> 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 here:
>
> http://cpearson.com/excel/colors.htm
>
>
> In article <[email protected]>,
> "Paulus" <[email protected]> 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. :-)