Could you explain exactly how to do this? I’ve been trying but can’t figure it out!
I know I drag down from the the bottom right corner of the cell to bring the formula down but how do I ‘point it to the cell’?
It worked, thank so much!!
1 Like
If you see the little blue square in the corner of your highlighted cell - if you click + hold on that, and then drag that down while holding, that will copy your formula down the sheet 
The Red Lion…not the one in Ealing by any chance ? Hello fellow ealing person lol
Of all the Red Lions in the world, no, it’s not the one in Ealing. I might have been there in the past, though. Near Ealing Broadway?
how did you get this working? I have something like zoom area requires valid geo data point I have set geo dimension to use address
yeah not far from there
1 Like
I’m very new to Google Sheets, and I’m trying something out. I wonder if someone can help me fix this:
I’ve got my Monzo export sheet (called July 2020), and then I’ve created a clean sheet for my calculations. I want a total of the Amount column, where the amount is below zero, and also exclude rows where the Notes and #tags field includes text that says #refunded and also exclude Type is Pot transfer.
I think I need to use sumifs, right? Here’s what I’ve got:
=SUMIFS('July 2020'!H2:H200,"<0")
but I get lost when I try to include the other two conditions…help!
=SUMIFS(‘July 2020’!H2:H200,“<0”,I:I,”Refunded”, J:J,”Pot Transfer”
Just swap I/J for your columns. That should do it
Thank you I’m getting a formula parse error on it, and I don’t understand why:
=SUMIFS(‘July 2020’!H2:H200,"<0",L2:L200,”Refunded”, D2:D200,”Pot Transfer”)
Are you missing the criteria range?
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
If you’ve copied and pasted, that’ll be down to how the Forum formats certain characters - it swaps apostrophes for a different character.
Try this:
=SUMIFS('July 2020'!H2:H200,"<0",L2:L200,"Refunded", D2:D200,"Pot Transfer")
Should be copy and pastable. If that doesn’t work it’s something else. (also, I’d recommend just using L:L and D:D rather than numbers - will keep your formula future proof!
EDIT: There is some order of field problems too. Assuming H is the Value, L is the Refund column, D is the Pot Transfer column, try this.
=SUMIFS('July 2020'!H2:H200,'July 2020'!H2:H200,"<0",L2:L200,"Refunded", D2:D200,"Pot Transfer")
Basically you need to reference col H again.
1 Like
Got it! Thank you it’s not producing an error anymore, but it’s giving me a zero value. I think that’s because the formula is looking for fields that include “#refunded” but I actually want to exclude those cells. How do I do that?
Ah easy - just add “<>” to the front of Refunded. That’s the operator for “Does not equal”.
Edit, just to note that this will be case sensitive though, so will only return anything that matches exactly what you put in quotes, I believe
1 Like
YES! It worked 
Thank you so much for all of that, that’s super helpful!
2 Likes
Hi Paul
Terribly sorry for not responding sooner
I cannot get it working terribly well myself, as the Google Maps plugin does not like me setting the tooltip to the merchant name as apparently some of my addresses have multiple merchant names (though that is another thread on here!)
I did the following:
So not very complicated, once I worked it out, but also not that useful given that I cannot add the merchant name to the tooltip right now
Interestingly, monzo have added ‘money in’ / ‘money out’ columns to the data export;
It includes pot transfers. Its basically a repeat of the data found in the ‘local amount’ column, just split dependent on whether its a negative or positive value. I wonder why they’ve done this…
3 Likes
Interesting!
But why not post and explain why? I’m going to guess something to do with credit card pots.
1 Like
Ooh that’s interesting!
I made a comment how that view might be useful for Pot Transfers - as currently they miss interest.
I wonder if that will follow.
Does this also mean calculations are broken?
Doesn’t seem to have broken any of my calculations, since they’ve just added additional columns and left the original columns unchanged from what I can tell.
Maybe someone from monzo could explain the rationale
I guess the main thing this achieves is it makes it slightly easier to tally up incomings and outgoings separately