- 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 1:26 pm to LSUtigerME
Posted on 3/5/15 at 1:26 pm to LSUtigerME
Yes, the cells are formatted as dates. If it would simplify things, I could stick a row at the top with the month name. It would eliminate the need for using a wildcard.
Posted on 3/5/15 at 2:37 pm to h0bnail
quote:
Yes, the cells are formatted as dates. If it would simplify things, I could stick a row at the top with the month name. It would eliminate the need for using a wildcard.
Will you always want to total for only one month? You can use the SumIf or SumIfs, but your date range will non-dynamic. If you include a cell to specify the dates you want to sum between, the above formula works well.
If only the one month, you can use some combination of Datevalue and the number days in the month.
ETA: Datevalue("[month name]"&" 1") will return excel date code for that month in the current year. You can use EOMonth formula R determine the excel code for the last day of that month.
This post was edited on 3/5/15 at 2:40 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News