David Yes I have, I think the issue is the reference (the formula) not being correct on the cells? I’m not too familiar with Google sheets also, unfortunately. . But I know a bit of my way around. .
- On the “Cash flow analysis” tab it reads “=ARRAYFORMULA(‘Receipts analysis’!E2:2)”
- On the “Receipt analysis” tab it reads “=IF($A3=”“,”“,IF(E$1=”“,”“,SUMIFS(Receipts!$E:$E,Receipts!$H:$H,$A3,Receipts!$F:$F,”<=“&E$1,Receipts!$F:$F,”>“&EOMONTH(E$1,-1))))”
If you refer to the images I posted above, I think it should get the information from the “G” column on my “Receipts” tab. . I added a couple of columns as I customized my spreadsheets, so I think that’s where the mess up is. But I would like to keep my spreadsheet reading the way that I have it.
All the rest is perfect! It’s just my “Receipts” / “Receivables” that are not reflecting as they should.
Thank you for your prompt response, by the way!