Average By Month

VinceF

New Member
Joined
Sep 22, 2007
Messages
49
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

Thanks in advance,
Vince


Example.jpg
 

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
Joined
Aug 18, 2011
Messages
6,502
Office Version
  1. 365
Platform
  1. Windows
Hi, then how about.

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

VinceF

New Member
Joined
Sep 22, 2007
Messages
49

ADVERTISEMENT

Hi, then how about.

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
Joined
Jun 13, 2019
Messages
65
Office Version
  1. 365
Platform
  1. Windows
It's dividing correctly Today's December that's why you are getting $32 :)
 

VinceF

New Member
Joined
Sep 22, 2007
Messages
49
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.
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top