software

I have an Excel spreadsheed of my service calls entered by date and including
columns for labor, parts, tax and total. I can select all the entries in any
given column and then click on the sigma icon to give me a grand total for
that column but what I really need is the ability to have subtotals for each
column at the end of each month. I am sure there is a way to do this, but I
don't know how. Any help would be appreciated.

Thanks

Ted

Ideally, your data would have a column for Month. Data would be sorted by
month, then you could do a Data, Subtotals to add a Subtotal everywhere the
month changes.

quot;Preacher Tedquot; wrote:

gt; I have an Excel spreadsheed of my service calls entered by date and including
gt; columns for labor, parts, tax and total. I can select all the entries in any
gt; given column and then click on the sigma icon to give me a grand total for
gt; that column but what I really need is the ability to have subtotals for each
gt; column at the end of each month. I am sure there is a way to do this, but I
gt; don't know how. Any help would be appreciated.
gt;
gt; Thanks
gt;
gt; Ted