Good morning,
These formulas:
=SUMIFS(RevenueALL!P$3:P$7238,RevenueALL!$B$3:$B$7238,$B$3,RevenueALL!$H$3:$H$7238,$C22)
=SUMIFS(RevenueALL!P$3:P$7238,RevenueALL!$B$3:$B$7238,$B$3,RevenueALL!$H$3:$H$7238,$C24)
and a few others like these all pull data from my RevenueALL tab based on a number of criteria including a refence to cell $B$3. That cell, $B$3 allows users to select a value from a drop down menu. These are working fine with one exception.
Whatever is selected in $B$3 references specific/individual markets we want to review data for. The exception is those times when we want to see the total for "All Markets", one of the drop down options in $B$3 as opposed to review data for a specific market. The problem is "there is no reference to "All Markets" on the RevenueALL tab. The column where it would go is being used to list an specific/individual.
I need to modify the formulas above so if "All Markets" is selected in $B$3 it will SUM all appropriate values. To explain further, look at the first formula. It needs to work exactly as it is now, but if All Markets is selected in $B$3 it should SUM all values in $P$3:$P$7238 in the RevenueALL tab where $H$3:$H$7238 = $C22 as opposed to only those for a specific market.
thanks in advance
These formulas:
=SUMIFS(RevenueALL!P$3:P$7238,RevenueALL!$B$3:$B$7238,$B$3,RevenueALL!$H$3:$H$7238,$C22)
=SUMIFS(RevenueALL!P$3:P$7238,RevenueALL!$B$3:$B$7238,$B$3,RevenueALL!$H$3:$H$7238,$C24)
and a few others like these all pull data from my RevenueALL tab based on a number of criteria including a refence to cell $B$3. That cell, $B$3 allows users to select a value from a drop down menu. These are working fine with one exception.
Whatever is selected in $B$3 references specific/individual markets we want to review data for. The exception is those times when we want to see the total for "All Markets", one of the drop down options in $B$3 as opposed to review data for a specific market. The problem is "there is no reference to "All Markets" on the RevenueALL tab. The column where it would go is being used to list an specific/individual.
I need to modify the formulas above so if "All Markets" is selected in $B$3 it will SUM all appropriate values. To explain further, look at the first formula. It needs to work exactly as it is now, but if All Markets is selected in $B$3 it should SUM all values in $P$3:$P$7238 in the RevenueALL tab where $H$3:$H$7238 = $C22 as opposed to only those for a specific market.
thanks in advance