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.
How can I remove "total" for those columns that are not selected?