subtotals and dates

  • Thread starter Thread starter mrsatroy
  • Start date Start date
M

mrsatroy

I have a list of information that I want to insert subtotals for. I want a
monthly subtotal for the information but my dates in the spreadsheet exist in
the format dd/mmm/yy. Consequently when I use the subtotal function it views
each day as a change in date and just counts the number of incidents per day
as opposed to per month which is what I want. I want it to look at the change
in the mmmm part of the date and subtotal as oppsed to the change in the dd
part.
Thanks in advance
 
One way, assuming field headers are in Row 1 and data starts on Row 2 and
dates in column D
Create a helper column(column G for the sake of an example) with field
header Month. It should be adjacent to the list.
In G2 enter the formula =month(D2),returns the month # (August is 8,
November is 11). Fill down to end of data.
For subtotals, at each change in Month, Sum, "select the field header to be
added"
Click OK.
That should do it.
 
Back
Top