# Get monthly total

#### Gvlewis81

##### Board Regular
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 ?

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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.

Replies
3
Views
179
Replies
3
Views
128
Replies
2
Views
231
Replies
1
Views
193
Replies
0
Views
210

1,207,012
Messages
6,076,147
Members
446,187
Latest member
LMill

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back