Well, cell XX is either blank or it's not, so:
=IF(XX="",SUM(YY:YY),SUM(ZZ:ZZ))
Regards
Trevor
"esulpher" wrote in
message ...
I am trying to use an IF statement involving two arguments - IF Cell XX
is = "blank" then bring back the SUM of Cells XX-XX BUT IF Cell XX
[this is the same cell as the first reference] is = "non blank" then
bring back the SUM of Cells YY-YY. Is this possible? If so how would
I do this?
Thank you
--
esulpher
------------------------------------------------------------------------
esulpher's Profile:
http://www.excelforum.com/member.php...o&userid=36606
View this thread: http://www.excelforum.com/showthread...hreadid=563477