- 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 12:10 pm to jeekers78
Posted on 3/5/15 at 12:10 pm to jeekers78
SumIFs will work, but you'll have to convert the date range to Excel Date code. The wildcard won't work in that format difference.
If you have two other cells you can use to define the date range, it'll be easy. Cell A is lowest date, Cell B is higher date.
= SumIfs(Y1:Y99, X1:X99, ">="&Cell A, X1:X99, "<="&Cell B)
ETA: there's some assumptions, mainly that the dates are actual date format, and not text. If text, the wildcard will work and SumIf only required (assuming you only want to sum the month without multiple years and no other functionality required).
If you have two other cells you can use to define the date range, it'll be easy. Cell A is lowest date, Cell B is higher date.
= SumIfs(Y1:Y99, X1:X99, ">="&Cell A, X1:X99, "<="&Cell B)
ETA: there's some assumptions, mainly that the dates are actual date format, and not text. If text, the wildcard will work and SumIf only required (assuming you only want to sum the month without multiple years and no other functionality required).
This post was edited on 3/5/15 at 12:21 pm
1
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.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News