Hi all,
I have a LARGE, IF array formula with several criteria that returns certain data depending on the criteria selected from my Form Control Combo Box. One of my criteria is looking at the province/prefecture of a country and then returning data for each. So far so good. Though, I also need the data for the whole (!) country, thus ignoring the prefecture if "Total Japan" is selected from my combobox. The 'main' array formula is the following:
Since I have many (!) IF statements already (not illustrated in the above), I cannot use another otherwise the formula would exceed the maximum allowed limit. Hence, I need to somehow get Excel to return data for ALL prefectures whenever $Q$36="TOTAL JAPAN" within the IF statement:Please Login or Register to view this content.
I tried to havePlease Login or Register to view this content.
orPlease Login or Register to view this content.
whenever Total Japan is selected in my combobox in order to have Excel ignore the prefecture, but that doesn't seem to work, it only works with SUMIF and SUMPRODUCT formulas as far as I am concerned. Any tips?Please Login or Register to view this content.
Bookmarks