Forum Discussion

Kimberly Farrell's avatar
Kimberly Farrell
Copper Contributor
Jan 17, 2018

Formula help

Hi, I have what is probably a basic question but I'm having a moment and can't figure it out!   I want to do a simple sum formula but exclude one column only if it contains a percentage.  Som...
Formulas & Functions
Need Help
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 17, 2018

This formula is fairly good:

=SUMIF(A1:A10,">=1",A1:A10)

But it ignores all percentage values except 100% and above.

 

  • Kimberly Farrell's avatar
    Kimberly Farrell
    Copper Contributor
    Jan 17, 2018

    it worked ! Thank you

     

    I have something funky going on though - when I enter a formula it calcs on the line no problem but when I pull it down to copy to another line it won't calc out unless I go in to the formula and hit enter.  Any changes in the data I make I have to go to the formula and hit enter again to have it recalc.

     

    Any thoughts?

     

    Thanks again !

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Jan 18, 2018

      As Willy reply, the calculation option is manual.

      Go to Formulas >> Calculation >> Calculation Options >> Automatic

      • Kimberly Farrell's avatar
        Kimberly Farrell
        Copper Contributor
        Jan 18, 2018

        Thank you !! 

    • Willy Lau's avatar
      Willy Lau
      Steel Contributor
      Jan 18, 2018

      Try click on Formulas tab in Ribbon.  Click Calculation Options and select Automatic.

Resources