# Telling excel to ignore blank cells in SUM formulas

1. ## Telling excel to ignore blank cells in SUM formulas

Hi There

Im trying to Sum the total of a number of cells using the following formula:
=SUM(F57,H57,J57,L57,P57,N57,D57,,R57,V57,T57,X57)

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.

2. Assuming there are no cells with text, the SUM function is redundant; just

=F57+H57+J57 ...

3. ## 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:
=SUMPRODUCT((F58:X58=1)*(F57:X57<>"")*(F57:X57))

HTH
Ola

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1