Hi,
I'm trying to get a SUMIFS to work over two worksheets, (one returning the result of the formula from data held in the other), and I can't get it to work.
The attached file shows the data and the workings - it's a cashbook, (where the data is held), with a cashflow report for a specific project on the other, (where the result needs to go).
In cell K11 on sheet "CF report" - I want it to sum values from the sheet "Cashbook v2". It needs to:
1) Look at the project reference in cell A2 on the "CF report" sheet and look it up in column G on the "Cashbook v2" sheet
2) Look at the heading in col A, (in this case A11 - Income - Gifts / Donations), on the "CF report" sheet and look it up in column E on the "Cashbook v2" sheet
3) Look at the date in row 4, (in this case cell K4 = Aug-2022), on the "CF report" and look it up in column K on the "Cashbook v2" sheet
4) Return me the sum of values in column H on the "Cashbook v2" sheet in cell K11 on the "CF report" sheet
The manual calculation in cell K11 on the "CF report" worksheet is what the value should be.
Any help is greatly appreciated.
Thank you,
Lindsey
Bookmarks