subtotal on 2 columns
 

I have 3 fields: CustNo, CustName, Amount
I want to subtotal the Amount column by either the customer number or the
customer name but I want both of those values (CustNo and CustName) to appear
on the subtotal line. Currently only the one field that I subtotal by will
appear on the subtotal line. My workaround is to make the blank cell equal to
the one above it and then copy/paste special values but I am wondering if
there is an easier way to do this.

subtotal on 2 columns
 

If each customer name has only one number, you can add a column and use the
Concantenate function to combine CustNo and CustName into one cell which you
can use for subtotals.



"moon11" wrote:

I have 3 fields: CustNo, CustName, Amount
I want to subtotal the Amount column by either the customer number or the
customer name but I want both of those values (CustNo and CustName) to appear
on the subtotal line. Currently only the one field that I subtotal by will
appear on the subtotal line. My workaround is to make the blank cell equal to
the one above it and then copy/paste special values but I am wondering if
there is an easier way to do this.