- 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
re: Excel Gurus, Converge!
Posted on 3/5/15 at 4:29 pm to LSUtigerME
Posted on 3/5/15 at 4:29 pm to LSUtigerME
quote:
Will you always want to total for only one month?
I report monthly on the previous month. My end game is to pull all of this monthly data into a new sheet, so that I can configure lookup to populate the monthly report sheet that I distribute. This is how my daily report currently works(I enter the date, and the appropriate cells pull the data from the matching columns).
This post was edited on 3/5/15 at 4:45 pm
Posted on 3/5/15 at 4:51 pm to h0bnail
quote:
I report monthly on the previous month. My end game is to pull all of this monthly data into a new sheet, so that I can configure lookup to populate the monthly report sheet that I distribute. This is how my daily report currently works(I enter the date, and the appropriate cells pull the data from the matching columns).
In that case, use this formula off to the right instead:
=SUMIF(B1:B100, MONTH(TODAY())-1, C1:C100)
This post was edited on 3/5/15 at 4:56 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News