Sum parts of a column
 

Hi again,

I am still having trouble with suming parts of a column. Can someone please
help. I have changed my thinking since my post on 8th Sept.

Column H has various numbers in it. Column F has some blanks and some
numbers. What I want to do is....

Sum column H until a row has a number in F that is less than 899 and is not
blank (blanks get sumed with numbers above 899). do not include this row in
sum total. Place total in Column I.

I hope that this makes sense.

Thanks

Roger

Sum parts of a column
 

How about showing us an example of your data and tell us what result you
expect.

--
Biff
Microsoft Excel MVP


"Roger Dodger" wrote in message
...
Hi again,

I am still having trouble with suming parts of a column. Can someone
please help. I have changed my thinking since my post on 8th Sept.

Column H has various numbers in it. Column F has some blanks and some
numbers. What I want to do is....

Sum column H until a row has a number in F that is less than 899 and is
not blank (blanks get sumed with numbers above 899). do not include this
row in sum total. Place total in Column I.

I hope that this makes sense.

Thanks

Roger

Sum parts of a column
 

Hi Roger,

I'm not sure whether I read your request correctly. Pls verify my example.
First I assume if you meet a blank or 899 value, you will ignore the
following rows.
If you can assign an extra column let say G in this case.
Formula G1 will be =IF(OR(F1="",F1899),FALSE,TRUE), and drag down to end of
F datas.
I1 will be =SUM(INDIRECT("$H$1:H"&MATCH(FALSE,G:G,0)-1))
F G H I
1 500 TRUE 1325 13456
2 123 TRUE 12131
3 FALSE 5151
4 5656 FALSE 1210
5 FALSE 213
6 500 TRUE 515
7 125 TRUE 21
8 3588 FALSE 21
9 65 TRUE 23
10 11 TRUE 123
11 115 TRUE 123


"Roger Dodger" wrote:

Hi again,

I am still having trouble with suming parts of a column. Can someone please
help. I have changed my thinking since my post on 8th Sept.

Column H has various numbers in it. Column F has some blanks and some
numbers. What I want to do is....

Sum column H until a row has a number in F that is less than 899 and is not
blank (blanks get sumed with numbers above 899). do not include this row in
sum total. Place total in Column I.

I hope that this makes sense.

Thanks

Roger