ISBLANK DOESN'T GIVE CORRECT
Posted by mark cheatum on September 19, 2001 7:45 AM
AM TRYING TO CREATE A SHEET THAT SUMS OF B3:B33 ARE ADDED TOGETHER, BUT IF NOTHING IS IN THOSE CELLS LEAVE B34 TOTALLY CELL BLANK. THIS IS WHAT I HAVE NOW AND IT IS NOT RIGHT.
=IF(isblank," ","SUM(B3:B33)")
CAN SOMEONE HELP, AM LEARNING EXCEL WAS A LOTUS MAN FOR YEARS.