Nov 17 2020 08:23 PM
I use MS Excel for mac. I use =SUMIF to add expenses in items I buy. All of my items work with =SUMIF except one. The items give me the correct amount totals for each item except one which give me "0".
Nov 17 2020 08:44 PM
Check the spelling of the item in your table and your reference. Take care of the hidden characters such as extra spaces.