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

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

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

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

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

I don't know which statement the error is occuring.

The =AND(ISBLANK(A1),ISBLANK(B1),ISBLANK(C1)) function should never give a
VALUE# error. You need to put this function on everyline including the blank
lines.


Therefore the error must be on the

=IF(AND(F1,F2),D3,E2+D3)
Let me know which row you are putting this line

This is designed to be on row 3.
The F1 is two rows before row 3
The F2 and E2 are on one row before row 3
And the D3 is on the same row which is row 3.

You can highlight the cell that has the error. Then go to Tools Menu -
formula Auditing - Evaluate formula. The press Evaluate until the error is
shown in the box. this will tell where the problem is. I think the problem
is that there isn'teither a True or false in every row on column 5.



"belvy123" wrote:

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