Log in

View Full Version : Excel 2010 formula help I want to add a1 throgh z1 but if it is a (-) amount I want I

krishere2
Jan 16, 2012, 07:26 PM
Excel 2010 formula help I want to add a1 through z1 but if it is a (-) amount I want it to not count as a or -
JBeaucaire
Jan 19, 2012, 08:36 AM
You want to sum all the positive values in A1:Z1 ? This formula should do that:

=SUMIF(A1:Z1, ">0", A1:Z1)