Forum Discussion
Kimberly Farrell
Jan 17, 2018Copper Contributor
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...
Haytham Amairah
Silver Contributor
This formula is fairly good:
=SUMIF(A1:A10,">=1",A1:A10)
But it ignores all percentage values except 100% and above.
Kimberly Farrell
Jan 17, 2018Copper Contributor
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 AmairahJan 18, 2018Silver Contributor
As Willy reply, the calculation option is manual.
Go to Formulas >> Calculation >> Calculation Options >> Automatic
- Kimberly FarrellJan 18, 2018Copper Contributor
Thank you !!
- Willy LauJan 18, 2018Steel ContributorIf Haytham Amairah's reply fit your needs, it is probably the solution. Please mark it as the solution, and so others who have the same question can find the solution.
- Willy LauJan 18, 2018Steel Contributor
Try click on Formulas tab in Ribbon. Click Calculation Options and select Automatic.