Excel =SUMIF

Copper Contributor

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

1 Reply

@joea115 

Check the spelling of the item in your table and your reference. Take care of the hidden characters such as extra spaces.