L
Lee Grant
Hi there,
I'm trying to add some values in a column.
I have a column (d3 to d50). I need to sum every third row (ie D5, D8, D11,
D17 etc.) The problem seems to be that in two rows above each third row
there may or may not be some data. I have a formula in each third row to
check if the two rows above have some data in and if so multiply them. If
not I want nothing to be displayed.
Example:
D3 contains at time 00:47:20
D4 could contain a value if inputed by the user
D5 contains =IF(OR(D3="",D4="")," ",(D3-D4)
This series of three continues to the bottom of the column.
I discovered that SUM ignores text but some some reason when I do a
=sum(d5+d8+d11+d17..etc. forumla I get a #value error. I'm guessing this is
due to the " " that is inserted into the third row cells with the formula
(in the example =IF(OR(D3="",D4="")," ",(D3-D4)).
I'm stumped and I'm hoping one of your guys can use your genius to point me
in the correct direction and point out my obvious error.
Cheers
Lee
I'm trying to add some values in a column.
I have a column (d3 to d50). I need to sum every third row (ie D5, D8, D11,
D17 etc.) The problem seems to be that in two rows above each third row
there may or may not be some data. I have a formula in each third row to
check if the two rows above have some data in and if so multiply them. If
not I want nothing to be displayed.
Example:
D3 contains at time 00:47:20
D4 could contain a value if inputed by the user
D5 contains =IF(OR(D3="",D4="")," ",(D3-D4)
This series of three continues to the bottom of the column.
I discovered that SUM ignores text but some some reason when I do a
=sum(d5+d8+d11+d17..etc. forumla I get a #value error. I'm guessing this is
due to the " " that is inserted into the third row cells with the formula
(in the example =IF(OR(D3="",D4="")," ",(D3-D4)).
I'm stumped and I'm hoping one of your guys can use your genius to point me
in the correct direction and point out my obvious error.
Cheers
Lee