VinceF
Board Regular
- Joined
- Sep 22, 2007
- Messages
- 172
- Office Version
- 2016
- Platform
- Windows
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
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