sum if function

[smithyy156]

how can i sum a group of cells if one specific cell is greater than 0. for example if i want to sum e2:i2 but only if e2 is greater than 0 what formula do i write? any help appreciated thanks

 

[mumps]

Try: =SUMIF(E2:I2,">0",E2:I2)

 

[Fluff]

Alternatively
=IF(E2>0,SUM(E2:I2),"")

 

[snjpverma]

another way

=(E2>0)*SUM(E2:I2)