I have all my spending added to a google sheets via IFTTT. I’m now trying to create a tracker on that same spreadsheet but I can’t seem to get the formula to work? Is it something to do with the way the data is being input?

Here’s my sheet. I’m trying to use the formula to get the amounts put into the table. I’ll then link that cell with the next sheet so it can be added to the tracker & eventually make it so it adds everything up automatically.

I can’t seem to get the SUMIF formula to work, any ideas?

I’ve sorted it for you. The numbers coming in are text, so you need a column that converts these into numbers. You then use SUMIF to sum those numbers.

I actually really like sheets over excel! A lot of the help guides online and the training at my work are for excel though which doesn’t always translate over the same!