Forum Discussion
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. Sometimes it will contain a number, which I want the formula to then add. But ignore it if it's a percentage.
Thank you!!
This formula is fairly good:
=SUMIF(A1:A10,">=1",A1:A10)
But it ignores all percentage values except 100% and above.
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 !
As Willy reply, the calculation option is manual.
Go to Formulas >> Calculation >> Calculation Options >> Automatic
