Chupis
New Member
- Joined
- Jan 25, 2005
- Messages
- 16
I have a workbook thousands of records long. I am using subtotal (count) to divide the data into categories and provide count subtotals on two of the columns. My problem is I need to do a "sum" subtotal on another column using the same line as the other subtotals.
my limitations: I cannot use a macro (this file is replaced/configured daily) and I cannot add another line between cell groups (which is what doing a subtotal(count) will do).
I guess my question is how can I sum cells between empty cells all the way down to my last record? Keep in mind all my cell groups vary in length.
my limitations: I cannot use a macro (this file is replaced/configured daily) and I cannot add another line between cell groups (which is what doing a subtotal(count) will do).
I guess my question is how can I sum cells between empty cells all the way down to my last record? Keep in mind all my cell groups vary in length.