Subtotal

2

240

I have a spreadsheet with a large amount of data grouped by department
belonging to several departments. The data are arranged in columns ranging
from "A-CA" . I would like to add a subtotal to each changing account. I
tried using the subtotal function and it worked to a certain extinct.
However, the subtotal feature only captures columns "A-Xâ€, but does not
allows me to subtotal the remaining columns "Y-CA".
Can someone help?
 

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

Similar Threads

Getting Text data using the Data - Subtotal feature 1
Display Multiple Cells when Using Subtotal Function 0
Subtotal To Include Item Description On Subtotal Line 2
subtotal data from 2 columns into 3rd column 1
Macro Pause to Select range then Subtotal 0
SUBTOTAL QUERY 5
subtotal filter with growing range 2
% of subtotal in pivot table 1

Top