Counting income and outgoings in 2 month periods, Works perfectly March to November, but not after this?
Formulas on the GST Summary tab
https://docs.google.com/spreadsheets/d/10KffbQ29vr8c7gz2bep3kX0-U92SAxM81rzUB9kdzbs/edit?usp=sharing
-
Welcome to Web Applications Stack Exchange. The sample spreadsheet gives "Access denied." See The correct way to publicly share a Google test sheet.– doubleunaryJun 11, 2021 at 9:55
-
Not being able to see your sheet, I'm guessing that the cross-over between December and January (i.e., between one year and another) may be the problem, if you didn't account for this at the outset. But as doubleunary points out, your sheet is currently inaccessible. So that guess is all I can offer.– Erik TylerJun 11, 2021 at 11:50
-
I’m voting to close this question because it doesn't include the information needed to answer.– Blindspots ♦Nov 2 at 22:42
Add a comment
|
1 Answer
thanks for your input. I changed the sumifs, to sum with a filter, and that's fixed the across years error. Really appreciate your comments. Cheers