- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Dumb spreadsheet question..how do I get a monthly average for an incomplete year?
Posted on 8/16/17 at 3:36 pm
Posted on 8/16/17 at 3:36 pm
i know i'm missing something very easy, but i have a calendar spreadsheet covering multiple years.
i divide monthly by 12 to get monthly average for each year.
for 2017, the year isn't complete so how could i make the average accurate for the months so far?
is there a way to note if certain cells are empty and change the divider from 12 months to only the number of months with values in the cells so far?
yes cad is a moron. come at me.
i divide monthly by 12 to get monthly average for each year.
for 2017, the year isn't complete so how could i make the average accurate for the months so far?
is there a way to note if certain cells are empty and change the divider from 12 months to only the number of months with values in the cells so far?
yes cad is a moron. come at me.
This post was edited on 8/16/17 at 3:40 pm
2
Posted on 8/16/17 at 3:40 pm to CAD703X
How is the spreadsheet setup?
You could use month() to get the number of the month you're interested in.
Countif() or counta() or count() will do what you ask though
You could use month() to get the number of the month you're interested in.
Countif() or counta() or count() will do what you ask though
Posted on 8/16/17 at 3:55 pm to CAD703X
=average(range)
As long as you don't have 0 in the months that haven't happened yet.
As long as you don't have 0 in the months that haven't happened yet.
Posted on 8/16/17 at 4:36 pm to CubsFanBudMan
quote:
CubsFanBudMan
yup that did the trick. didn't realize that wouldn't average empty cells.
thank you!
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News