Subtotal
 

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?