Previous Topic Next Topic

Problem with formula using ISBLANK

Solved/Closed
peweuk Posts 3 Registration date Sunday February 1, 2015 Status Member Last seen February 5, 2015 - Feb 5, 2015 at 06:43 AM
Hello,

I am using the ISBLANK function to execute formulas in my spread sheet.

If I use a formula to add or subtract, such as
=IF(ISBLANK(D13),"",($A$1-D13))
the result is correct.

However if I use a similar formula to sum a column, such as
=IF(ISBLANK(D13),"",($A$3:A13))
instead of showing the total of cells A3 to A13, the result simply shows the value of cell A13.

Does ISBLANK not work with sums, or am I missing something???

TIA


EDIT/UPDATE:

Found the problem - missing SUM
=IF(ISBLANK(D13),"",SUM($A$3:A13))