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.
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!