Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count total month per year
Hi all,
I have a table like this Name submit date A 10-Jan-2006 B 13-Jan-2006 C 25-Feb-2006 A 5-Jul-2007 D 18-Aug-2007 C 23- Oct-2007 Questions: 1. how to count the total entries of each month per year and total entries per year, ignoring the first column; so I will have Jan-2006=2 entries, Feb-2006=1 entries; also 2006=3 entries, etc. 2. how to count and relate the two column; so I will have A on Jan-2006 submitted 2 entries etc. Thank you so much for your help. Brie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
count total month per year
Use a pivot table and group the dates for months
http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot07.html -- Regards, Peo Sjoblom "Brie" wrote in message ... Hi all, I have a table like this Name submit date A 10-Jan-2006 B 13-Jan-2006 C 25-Feb-2006 A 5-Jul-2007 D 18-Aug-2007 C 23- Oct-2007 Questions: 1. how to count the total entries of each month per year and total entries per year, ignoring the first column; so I will have Jan-2006=2 entries, Feb-2006=1 entries; also 2006=3 entries, etc. 2. how to count and relate the two column; so I will have A on Jan-2006 submitted 2 entries etc. Thank you so much for your help. Brie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
count total month per year
Peo:
Thank you for this. Took me some time to learn and test it. I had to squeeze my brain v hard :) but finally I got it. Quite fun too! Brie "Peo Sjoblom" wrote: Use a pivot table and group the dates for months http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot07.html -- Regards, Peo Sjoblom "Brie" wrote in message ... Hi all, I have a table like this Name submit date A 10-Jan-2006 B 13-Jan-2006 C 25-Feb-2006 A 5-Jul-2007 D 18-Aug-2007 C 23- Oct-2007 Questions: 1. how to count the total entries of each month per year and total entries per year, ignoring the first column; so I will have Jan-2006=2 entries, Feb-2006=1 entries; also 2006=3 entries, etc. 2. how to count and relate the two column; so I will have A on Jan-2006 submitted 2 entries etc. Thank you so much for your help. Brie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if i save 25.00 a month for 40 years at 5% a year whats the total | Excel Discussion (Misc queries) | |||
count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
count dates within range by year and month | Excel Worksheet Functions | |||
Get count of records for a particular month and year | Excel Discussion (Misc queries) | |||
how to calculate total months from month/year | Excel Discussion (Misc queries) |