Announcement

Collapse
No announcement yet.

The sum of a suffering error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • The sum of a suffering error



    hi

    How can I collect cells in one suffering while there are cells with errors?
    جمع اعداد در بازه دارای خطا : هنگامی که می خواهیم عملیات جمع را در رنجی که دارای سلولهایی است که حاوی خطا هستند انجام دهیم ، دچار مشکل می شویم ، در این حالت

  • #2
    Hi,

    Two questions :

    1. Why do you have errors ?

    2. Why you are not getting rid of errors ?
    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment


    • #3
      Hello
      I just want to combine the suffering of the numbers together
      Within it there are a number of sufferings that have been erroneous, such as the division of numbers by zero

      Comment


      • #4
        Hello,

        In cell C2 ....
        Code:
        =IF(B2,A2/B2,0)
        Copy formula down to row 8 ...

        In cell C9 ...
        Code:
        =SUM(C2:C8)
        Hope this will help
        If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

        Comment


        • #5


          Hello,

          Feel free to share your comments ...
          If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

          Comment

          Working...
          X