Aggregating summed data from one worksheet to another

[USAOzi]

OK, this is a tricky one and I have NO idea where to begin to solve it but I'm fairly certain there is a way to do this.


I have a workbook with two worksheets. One is named Expenses, the other Itemised Expenses.


The Itemised Expenses worksheet has several columns but the salient ones are Column A that contains the dates of the expenses transaction(s) and to the right (several columns) is the amount of the expenditure.


These expenses need to be aggregated to a specific date on the Expenses worksheet.


For example, on the Expenses worksheet are dates of logged employment. Against each of these dates I need to su all of the expense transactions that occured on or before the employment date.


E.g.


Work Date Expense Date Expense
20 Sep 17 18 Sep 17 10.00
21 Sep 17 19 Sep 17 20.00
27 Sep 17 20 Sep 17 30.00
21 Sep 17 10.00
22 Sep 17 20.00
25 Sep 17 20.00


I want Column B of the Expense worksheet to show the amount of 60.00 against the date of 20 Sep 17 in column A; the amount of 10.00 against the date 21 Sep 17 and the amount of 40.00 against the date 27 Sep 17.


Do any of you Excel gurus out there know how this could be formulated?


Thanks in advance for any help on this.

 

[Aladin Akyurek]

Try a pivot table or have a look at the SUMIFS function.

 

[USAOzi]

Try a pivot table or have a look at the SUMIFS function.

I've tried every permutation of the sumifs function but it always throws and error so I'm not understanding the logic of its parameters.
Thanks for the advice anyway despite it not being really useful.