Budget Spreadsheet with Breakdown by Month/Category

[yomandenver]

I'm creating a budget spreadsheet that I want to show a breakdown by month and category what was spent on what per month.

The formula I'm trying to use (which is probably wrong), goes something like this:

=IF(Expenses!D4:D50=MEDIAN(Data!B2,Data!C2)AND(Expenses!E4:E50="Utilities")),VLOOKUP(Expenses!C4:C50))

Expenses!D4:D50 is the date of transaction
Data!B2 is the first day of the month
Data!C2 is the last day of the month
Expenses!E4 is the category (Mortgage/Rent, Groceries, Utilities, etc.)
Expenses!C4 is the amount

Is there a better way to do this?

 

[ParamRay]

.
.

I think you want the SUMIFS function: https://support.office.com/en-US/Article/SUMIFS-function-9dd6179e-cced-41dd-ac38-08fdf5b929e5

You probably want to adapt something like this:

=SUMIFS(Expenses!F:F,Expenses!D:D,">="&DATE(2014,10,1),Expenses!D:D,"<"&DATE(2014,11,1),Expenses!E:E,"Ulilities")

 

[yomandenver]

.
.

I think you want the SUMIFS function: https://support.office.com/en-US/Article/SUMIFS-function-9dd6179e-cced-41dd-ac38-08fdf5b929e5

Perfect, thank you!