Total column if in date range

  • Thread starter Thread starter Nora
  • Start date Start date
N

Nora

I have a spreadsheet that has statistics on employee incidents. On
column has date of each incident then columns with dollar amounts tha
correspond to the types of incidents. I need to create a worksheet o
subtotals by calendar quarter by type of incident. I can't seem t
figure out how to sort for a date range and subtotal each type.

YELP
 
Yelp?

Assume the dates column is in A2 going down, insert a help column B (call it
Help)
in B2 put

="Q"&INT((MONTH(A2)+2)/3)

copy down as long as needed

now select the tables and do data>subtotal and select at each change in
Help,
add subtotal to: (the column with the amounts)
 
Nora,

First, add a helper column that yields the quarter:

=INT((MONTH(A2)-1)/3)+1
= "Qtr " & INT((MONTH(A2)-1)/3)+1

Now you can make a pivot table that groups by this column, or sort it on
that column, then use Data - Subtotals.

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
="Q"&INT((MONTH(A2)+2)/3)

Excellent, except one minor point...let's not forget our Y2K lessons!

="Q"&INT((MONTH(A2)+2)/3)"-"&YEAR(A2
 
Back
Top