2 Replies Latest reply on Apr 4, 2016 10:40 AM by Gareth Crawford

    How to remove "Total" placeholder text from subtotal

    Gareth Crawford

      Good day, folks,

       

      I have a sheet that enables users to change parameters by using series of drop down menus (similar to this). The sheet is a summary of our stock: if the user selects certain criteria, the count changes. There are 4 parameters in total. The more parameters that are selected, the more granular the results are.

       

      To help the users, I created a 'sub total' for each row. The sub totals worked, but now the word 'total' appears all over the sheet, even if nothing is selected. For example, in the below, only column 1 is selected and yet "total" appears three times.

       

      Subtotals.png

       

      How can I remove "total" for those columns that are not selected?