Does anyone know how to make the formula below return nothing unless AB1 has an entry in its cell?
=SUM(X1+AE1)
Unless AB1 has information in it, I want this cell to appear blank. Thanks in advance.
Dan
Does anyone know how to make the formula below return nothing unless AB1 has an entry in its cell?
=SUM(X1+AE1)
Unless AB1 has information in it, I want this cell to appear blank. Thanks in advance.
Dan
Use an IF perhaps ?
IF(AB1="","",SUM(X1,AE1))
On an aside... the advantage to using SUM over + is that it does not explicitly coerce... for ex.
X1 = "apple" (user error)
AE1 is 10
=X1+AE1 --> #VALUE! as X1 is not numeric...
=SUM(X1,AE1) --> 10 given the SUM will only look at numeric values...
my point... there is thus little value in using
=SUM(X1+AE1)
as the benefits of the SUM are negated by the explicit coercion taking place within the SUM itself therefore if using X1+AE1 dispense with SUM and conversely if using the SUM dispense with the + operator and use , to delimit the ranges to be summed
(you are constrained in terms of how many areas you may delimit in the SUM)
Last edited by DonkeyOte; 11-09-2009 at 06:46 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks