Hi Again
It give me a Value# error when a row is blank

not sure why???

--
cruchnin numbers


"Joel" wrote:

the 6th column will be true if columns A, B and c are all blank and false if
they contain data. this column can then be used to determine if the running
total continues or it starts again froma value of zero.

the ISBLANK function could be added into the formula in the 5th column but
it would be harder to understant.

try adding the 6th column with the formula
=AND(ISBLANK(A1),ISBLANK(B1),ISBLANK(C1))

and I think you will understand what it is doing. make column A - c blank
and it will show TRUE. Add data to any of the columns A - C and it will show
FALSE.

When two rows adjacent rows of FALSE are shown then the running total will
be set back to zero and a new running total will be calculated.

"belvy123" wrote:

Thankyou for the reply Joel

I am not understanding the purpose of adding a 6th column
not able to follow the logic of your formula. I am rather new to this

Thanks
--
cruchnin numbers


"Joel" wrote:

I would add a new 6th column with the formula

for row 1 and copy to every row
=AND(ISBLANK(A1),ISBLANK(B1),ISBLANK(C1))

In the in the 5th column for the 1st and 2nd row I would not change anything
starting in Row 3 I woud have

=IF(AND(F1,F2),D3,E2+D3)

And(F1,F2) will be true when row 1 and Row 2 are both blank

You should have now for you running total in column E the formula =E2+D3.



"belvy123" wrote:

Hi All


I have a sheet where I have 3 columns of 35 rows where I input numbers from
3 different presses production. in a 4th column I total that shifts
production and in a 5th column I have a running total of all rows that have
been entered.

What I need is a formula that if I have 1 row that is empty in all 3 columns
it will carry down the running total for that row and if it has 2 or more
rows where all 3 columns are blank that it will not carry down that running
total
--
crunchnin numbers