I am trying to create a sort of tool where from sheet 'Report writer' I will be selecting the options for calculation from the drop down.
Based of these selection there is a sumif formula in 'Sheet5' Cell F5 which needs to give the results as per the selection.
Problem arises when I do not select on of the criteria and select 'All' it does not give me any value.
So if any one can help me in anyway to get the sum where I can do a multiple selection and where few of them may be All it should still give me the results based on the selection.
I am not sure if I have explained this well but attached is the file for your reference.
Thanks in advance for your help.