Telling excel to ignore blank cells in SUM formulas
Im trying to Sum the total of a number of cells using the following formula:
however some of those cells might be blanks as they are dependant on other data. The probelm im having is that when they are blank i am getting the the sum as 0. i know this isnt the case but dont know how to rectify my code.
Assuming there are no cells with text, the SUM function is redundant; just
Sum discontined blank formula cells
For a Discontinued range: (F57,H57,J57,L57,P57,N57,D57,,R57,V57,T57,X57)
The complicated way is to use: =IF(F57<>"",F57)+IF(H57<>"",H57)+...
If you can make the range continous by for instance setting a 1 in row 58 for all cells that is to be calculated (and hide the row), then the formulas becomes easier:
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1