Seemingly out of nowhere, I am now unable to add new data to a long standing spreadsheet with SUMIF formulas on my MAC. The spreadsheet has multiple worksheets based on yearly income with many SUMIF formulas. Once I add any new data, I receive a #NAME? error. If I try to un-do the new data, the #NAME? error remains and it appears in all formulas, NOT just the cell that I am adding data to. I updated to the latest LibreOffice version and this did not help. I am SOOOO CONFUSED! Please help 
thank you!
Me too… because nobody can help you without a real Example.ods
Huh! Get a life and beat it
Oh sorry please, how could I have assumed you were asking for help
thats rich!! your snarky and peevish initial reply was clearly helpful. again, go away. thanks 
It might just be worth uploading a sample file that shows the issue; helpers can then see the exact problem rather than relying on a somewhat vague description of the issue.