I've attached a worksheet as an example of my problem.
I have a large spreadsheet with many columns of data. I'm using the DSUM function to report on data based around 3 Schemes A, B, C.
Therefore I would like to know the Cost of each Scheme, please bear in mind not every record has a Scheme attached to it.
This I have managed to do using the DSUM function.
However I would also like to add criteria:
The cost of each Scheme per a financial year that is selected.
Bookmarks