Average By Month

[VinceF]

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

 

[FormR]

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]

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

Good catch, my bad...it should be $48

 

[FormR]

Hi, then how about.

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

 

[VinceF]

Hi, then how about.

=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]

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

 

[VinceF]

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]

You're welcome and thanks for the feedback