I need a master item which will function as an If statement.
I have a series of values, each with a yes of a no. How do I add a master item which would tell, if yes for column A, then total. That total would then need to be divided the total of every possible value. So ideally it would would give you percentage of spend fulling under that specific category.
I am not able to adjust the excel sheet, or I would just make the changes there. Even when I try to do a simple average master item it says it is an invalid dimension.
Your help is most appreciated