View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Killer Killer is offline
external usenet poster
 
Posts: 80
Default If two Columns have Data enter the Amount Question!

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,"")
--
David Biddulph

"Killer" wrote in message
...
Example:

H10 = 12
I10 = Blank

Result should be left blank

If

H10 = 12
I10 = 8

Result should be 20

Thanks!