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).
--
David Biddulph

"Killer" wrote in message
...
Yes the Calculation are on automatic not manual.

"David Biddulph" wrote:

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.
--
David Biddulph

"Killer" wrote in message
...
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!

"David Biddulph" wrote:

=IF(COUNT(H10,I10)=2,H10+I10,"")

"Killer" wrote in message
...
Example:

H10 = 12
I10 = Blank

Result should be left blank

If

H10 = 12
I10 = 8

Result should be 20

Thanks!