Forum Discussion
SUMIF Problem
The message you're getting indicates there are two different formulas in the table column. One of the benefits to using a table is having the formula auto-fill to the bottom. To resolve it, clear the entire column and re-enter the formula and it will fill to the bottom.
Edit - it appears that column was formatted as text and not calculating. Please see the fixed copy attached.
Hi, Thank you very much for your response. I entered the formula just as you have it there (I even did a copy and paste to see if I had messed something up) and I get an "Inconsistent calculated column formula" code. I don't understand what I may be doing wrong.
Have you tried putting the formula in the attachment I had sent? I'm so confused.
Any help is greatly appreciated! Thank you.
Marie
The message you're getting indicates there are two different formulas in the table column. One of the benefits to using a table is having the formula auto-fill to the bottom. To resolve it, clear the entire column and re-enter the formula and it will fill to the bottom.
Edit - it appears that column was formatted as text and not calculating. Please see the fixed copy attached.
Not sure if my thank you message went through or not, but just in case it did not:
THANK YOU, THANK YOU, THANK YOU! I spent over a week trying everything I could think of to get this to work and was extremely frustrated. My son suggested I reach out this way and I was skeptical, I'm so thankful I listened to him. I appreciate your help more than I can express in words. I printed out your advice to refer to for any future formula issues I may have. Thank you again! May you have a very blessed day!
Marie
Thank you, Marie. Have a great day!