Sum parts of a column

R

Roger Dodger

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
 
E

eksh

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="",F1>899),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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top