View original (French)

Excel subtotals

brucine Posted messages 25173 Registration date   Status Member Last intervention   -  
brucine Posted messages 25173 Registration date   Status Member Last intervention   -

Hello,

In Excel 2019 I import a CSV file as usual with semicolon separators, each amount is messy preceded by its categories.

I made a subtotal of the amounts by "type" (in fact since it concerns standardized accounts accounting) which gives me these subtotals and the grand total without problem.

I can't find a way to also make a subtotal by key (for example after CG there are other types in the key Garage).

I do an extraction at the end of each month, I don't know if it will be easier to manually add the few monthly entries in the spreadsheet or to start over the import setup which will have the same result of cumulating to date.

Thanks.

2 answers

  1.
    danielc0 Posted messages 2215 Registration date   Status Member Last intervention   294
     

    Look at the attached workbook. I first did a subtotal by key and then by type without checking "replace existing subtotals":

    Daniel

    2
    1. brucine Posted messages 25173 Registration date   Status Member Last intervention   4 167
       

      Hello,

      Perfect, I didn’t understand how to generate two successive subtotals.

      Thank you.

      0
  2. danielc0 Posted messages 2215 Registration date   Status Member Last intervention   294
     

    Hello,

    A macro?

    Daniel

    0