Forum Discussion

Susan_Bell's avatar
Susan_Bell
Tin Contributor
Jan 11, 2024
Solved

SuM function

I am using the SUM function to add the total of a row of cells not all of which have values.  Some cells are empty, some have $0.00 and some have an actual amount.  I have selected the entire row of cells. They are not adding up to the correct sum.  For example, a row that has 

30.0030.0030.0030.00

as well as several 0.00 and many blanks is coming with $210 as the total.

4 Replies

    • Susan_Bell's avatar
      Susan_Bell
      Tin Contributor

      Harun24HR 

       

      never mind.  I found a circular error and corrected it.

      • Harun24HR's avatar
        Harun24HR
        Silver Contributor
        No issue. So, your problem is solved?