Average By Month

VinceF

New Member
Somewhat of a novice user here...

I have a running spreadsheet listing each months household expenses for given items. I'm trying to show a running average.
If for say it's August, in the preceding months I had expenses for a particular category in Jan, Feb, May & July...none in Mar, Apr & Jun.

I'd like to total the monies spent to date and get an monthly average taking into consideration the 3 months where there wasn't any money spent.
I'm thinking that the countif or countifs function and the "today" date function need to be used but I'm unable to make them work for this application.

In the example it shows the average to be \$127 when it should read \$76

Vince

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

FormR

MrExcel MVP
If for say it's August
In the example it shows the average to be \$127 when it should read \$76

Hi, if it's August - why should the average be \$76?

VinceF

New Member
Hi, if it's August - why should the average be \$76?
Good catch, my bad...it should be \$48

FormR

MrExcel MVP

Excel Formula:
``=SUM(D3:Z3)/MONTH(TODAY())``

VinceF

New Member

Excel Formula:
``=SUM(D3:Z3)/MONTH(TODAY())``
Thank you for the attempt, I'm sure that we're close to solving this. When I put in that formula it reported \$32. It appears that it's diving by 12 (\$380/12=\$32). If it's only August it should report \$48 (\$380/8=\$48)

aghaffar82

Board Regular
It's dividing correctly Today's December that's why you are getting \$32

VinceF

New Member
It's dividing correctly Today's December that's why you are getting \$32
Makes total sense...then it's working as it's supposed to...thank you for taking the time to help me out, it's very much appreciated.

aghaffar82

Board Regular
You're welcome and thanks for the feedback

Replies
1
Views
141
Replies
1
Views
104
Replies
2
Views
429
Replies
14
Views
284
Replies
3
Views
149

1,130,404
Messages
5,641,940
Members
417,249
Latest member
Quysinboy

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.

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