SUMIF

Options
Musa
Musa ✭
edited 12/09/19 in Formulas and Functions

Hi all,

 

I am trying to add a range of cells on condition that it does not contain any value that is equal to/or less than 0. for instance (12,45,24,0,65) should equal 0 and (12,24,24,10,65) give me 135.

anyone to help?

Tags:
· Share on FacebookShare on Twitter

Comments

  • Matt Hagler
    Matt Hagler ✭
    Options

    Musa,

     I think I've got a solution for you that you'll want to experiment with.  In this example the Sum of the numbers is in Column 1 and the other 5 numbers are in columns 2 through 6 respectively.

    =IF(AND([Column2]1 > 0, [Column3]1 > 0, [Column4]1 > 0, [Column5]1 > 0, [Column6]1 > 0), SUM([Column2]1:[Column6]1), 0)

     

    Capture.JPG

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!