Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel 2010 formula help I want to add a1 throgh z1 but if it is a (-) amount I want I (https://www.askmehelpdesk.com/showthread.php?t=628279)

  • Jan 16, 2012, 07:26 PM
    krishere2
    Excel 2010 formula help I want to add a1 throgh z1 but if it is a (-) amount I want I
    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 -
  • Jan 19, 2012, 08:36 AM
    JBeaucaire
    You want to sum all the positive values in A1:Z1 ? This formula should do that:

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

    • All times are GMT -7. The time now is 06:05 AM.