subtotal on 2 columns


G

Guest

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.
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top