I am working in an Excel Spreadsheet. Column 1 contains
outline levels I need to evaluate, when the number is
greater than 1 I want the activecell to be 3 columns
over. This is the column and cell where I want to sum
all entries where the cells in column 1 are greater than
1. I want the sum to continue until I encounter another
1 in column 1.

I appreciate any help you can give me. So far I have
been able to count the number of rows to sum below each
outline level 1, but am having trouble getting it to do
the sum. I am getting the count with a do loop and then
assigning it to a variable.

Norma

are you summing down or summing up.

--
Regards,
Tom Ogilvy

Norma wrote in message
...
I am working in an Excel Spreadsheet. Column 1 contains
outline levels I need to evaluate, when the number is
greater than 1 I want the activecell to be 3 columns
over. This is the column and cell where I want to sum
all entries where the cells in column 1 are greater than
1. I want the sum to continue until I encounter another
1 in column 1.

I appreciate any help you can give me. So far I have
been able to count the number of rows to sum below each
outline level 1, but am having trouble getting it to do
the sum. I am getting the count with a do loop and then
assigning it to a variable.

Norma