View original (French)

Sum of empty cell = 0

Solved
brotox Posted messages 93 Registration date   Status Member Last intervention   -  
brotox Posted messages 93 Registration date   Status Member Last intervention   -
Hello everyone,

I have a small problem regarding Excel:
I am currently doing calculations on a large number of Excel rows, and one of the steps involves summing each row by considering a part of the columns. However, sometimes all the cells in that section are empty...
What I would like is to have N/A or blank or anything that indicates that there is no value rather than getting 0 and being led to believe that there is one.

Do you have any ideas to help me, please? (Note that I cannot filter or sort to delete these rows because the order is important for my analysis)

Thank you in advance,

Guillaume

6 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    Simply like this: 
    =IF(SUM(B2:Z2)=0,"",SUM(B2:Z2))

    That way, if your row is empty, your sum will be too.
    --
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    2