Thread: If two Columns have Data enter the Amount Question!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default If two Columns have Data enter the Amount Question!
=IF(COUNT(H10:I10)=2,H10+I10,"")


"Killer" wrote:

Example:

H10 = 12
I10 = Blank

Result should be left blank

If

H10 = 12
I10 = 8

Result should be 20

Thanks!
Reply With QuoteReply With Quote