- 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:45 pm to h0bnail
Posted on 3/5/15 at 4:45 pm to h0bnail
Say column A has the date and column B has the info you want to sum.
Insert a column in between A and B. This will be "Month". So now column A is Date, column B is Month, and column C is Quantity.
Populate column B with =MONTH(A1). Drag and drop to fill the range, let's say it goes down 100 rows.
Now over to the right somewhere (say, column G) create a list of months, 1 through 12.
In column H use the following: =SUMIF(B$1:B$100, G1, C$1:C$100). Drag, drop, and have a beer.
Insert a column in between A and B. This will be "Month". So now column A is Date, column B is Month, and column C is Quantity.
Populate column B with =MONTH(A1). Drag and drop to fill the range, let's say it goes down 100 rows.
Now over to the right somewhere (say, column G) create a list of months, 1 through 12.
In column H use the following: =SUMIF(B$1:B$100, G1, C$1:C$100). Drag, drop, and have a beer.
Popular
Back to top
Follow TigerDroppings for LSU Football News