Get monthly total

[Gvlewis81]

Hello


i want to be able to display the total spent in a particular month. Is there a formula to do this ?

i have a sheet that has the start finish date against the area. Area is in column c start date F and finish I.

I have a separate sheet that works out total amount spent in an area. This is in column BP of the separate sheet.

it is quite a big spread sheet as it also breaks down to individuals who did the job. This is why I'm finding it a bit tricky to work out the amount spent in a month.

Can anyone help ?

 

[RonB1111]

Unless you only want to prorate the expenses evenly across months in the date range (I assume you want more than this), you also need the date of each expenditure to calculate the amount spent. The most likely formula to use is SIMIFS - here is a link explaining it:
Use SUMIFS() to sum by multiple conditions in Excel | TechRepublic

If you need help adapting this, please post sample data showing the cells containing the date of the expenditure, amount, and anything that you'd want subtotals by month of such as "area", "individual".

Another option is to use a Pivot Table if you data is set up appropriately.