If two Columns have Data enter the Amount Question!

K

Killer

Example:

H10 = 12
I10 = Blank

Result should be left blank

If

H10 = 12
I10 = 8

Result should be 20

Thanks!
 
T

The Rain

Apologies, gave you a formula for zero not for blanks that's why is important
listening to The Rain myself. Thanks Gord you became the rain.
 
K

Killer

Thanks guys for the help but I'm still getting a result if Column I10 has no
result. There will always be data in H10 but I10 has no result.

It keeps showing result from H10!

:
 
G

Gord Dibben

Did you look at my earlier post?

=IF(OR(H10="",(I10="")),"",H10+I10)

Will show blank if either cell is empty.


Gord Dibben MS Excel MVP
 
D

David Biddulph

If you're trying to tell us that I10 doesn't have a number but you're not
seeing a blank in the result, then you've either got the formula wrong, or a
problem with your calculation mode. Tools/ Options/ Calculation, set it to
Automatic not Manual.
 
K

Killer

Yes i gave this a try and it's still showing a data.

G10 has this formula
=IF(COUNT(F10,G10)=2,F10+G10,"")

I10 has this forumla
=SUMIF('W5'!$B$10:$B$49,$B8,'W5'!$AN$10:$AN$49)

J10 has this formula
=IF(OR(H10="",(I10="")),"",H10+I10)

Would the formula be the problem?
 
K

Killer

Yes the Calculation are on automatic not manual.

David Biddulph said:
If you're trying to tell us that I10 doesn't have a number but you're not
seeing a blank in the result, then you've either got the formula wrong, or a
problem with your calculation mode. Tools/ Options/ Calculation, set it to
Automatic not Manual.
Click to expand...
 
D

David Biddulph

So the likelihood is that your formula is wrong. Tell us what formula you
have (copy & paste, don't retype), what result you are getting, and what
values are in the input cells.

If you are getting a result from the formula dependent on the condition
=IF(COUNT(H10,I10)=2,... then set up an extra cell to see what result you
get from =COUNT(H10,I10), and if you can't see numbers in both H10 and I10,
check that you haven't got values which are invisible because of formatting
(either base formatting or conditional formatting).
 
D

David Biddulph

The cell that you were regarding as blank registered as TRUE if you did
=ISNUMBER(), and that's why the COUNT() came to 2.
The cell had a formula =SUMIF(), so it was neither blank nor empty.
 
K

Killer

Hey David

I don't follow what your suggesting!


David Biddulph said:
The cell that you were regarding as blank registered as TRUE if you did
=ISNUMBER(), and that's why the COUNT() came to 2.
The cell had a formula =SUMIF(), so it was neither blank nor empty.
Click to expand...
 
D

David Biddulph

You've got a number in the cell, so that's why it doesn't satisfy the
formula you were given. As ever, the secret in getting a working answer is
to ask the right question. Your subject line talked about "If two Columns
have Data", and the text of your question talked about "I10 = Blank" as the
condition for getting a blank answer, so those are the questions which I and
others answered, but you *do* have data, you *don't* have a blank, you have
a zero, and that is why the answer to the question you asked doesn't give
the result you wanted for the question you *didn't* ask. [This, of course,
is one danger in suppressing display of zero values. You need to remember
that they are still there, even if you decide you don't want to see them.]
 
Top