I am using sumifs to calculate multiple items based multiple criteria. My problems is that I have 5 key main filter points lets say A,B and C and these are them filtered by week D.
I want week to calculate always by with the A,B,and C there are multiple sub categories. My problem is that within this I wish to put an "All" option that will calculate all values within the categories based on the other categories or sub categories. This needs to work for all options and if 'All' is selected on all categories it will calculate the total for everything for the week (the week in formula below is "Raw!B:B,'Weekly Overview'!B11") I have been able to get an if function to work for just one category were if "All" is selected it calculates the entire category. When I try to use multiple if functions in the sumif I get #value error.
=IF($C$7="All",(SUMIFS(Raw!H:H,Raw!A:A,'Weekly Overview'!$C$5,Raw!C:C,'Weekly Overview'!$C$6,Raw!B:B,'Weekly Overview'!B11)),(SUMIFS(Raw!H:H,Raw!A:A,'Weekly Overview'!$C$5,Raw!C:C,'Weekly Overview'!$C$6,Raw!N:N,'Weekly Overview'!$C$7,Raw!B:B,'Weekly Overview'!B11)))
This is the formula i have used so far and am unsure how to structure the remaining.
Hope someone can assist. I have read other posts and wasn't able to find the answer but if it has been posted please point me in the right direction.