View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default sum only if a certain cell contains data

Hi,

One way:

=IF(A1="","",B1+C1)

in simple terms:

=IF(condidion, if true, if false)

HTH
Jean-Guy

"hydromagnet" wrote:

I am trying to figure out how to create a formula that will sum 2
cells only when another cell contains text or date. I have been unable
to find this within Excel. Can anyone offer a suggestion?