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?
|