Lately I have been replacing a lot of VBA code or complex spreadsheets since I discovered the miracle of pressing CTRL+SHIFT+ENTER.
In the example below, I am using the SUM formula to calculate the total Premium where Regions are ON or CC.
The problem is that I now have to change the formula to accomodate 15 different Regions, probably more in the future. As a work around I could add a VLOOKUP in column D like : if(isna(VLOOKUP(a2,f:f,0)),false,true) and add this column into the array formula, but I am hopeful that there's a way to solve this without adding auxiliary fields.
Any tips will be very helpul!
Many thanks
In the example below, I am using the SUM formula to calculate the total Premium where Regions are ON or CC.

The problem is that I now have to change the formula to accomodate 15 different Regions, probably more in the future. As a work around I could add a VLOOKUP in column D like : if(isna(VLOOKUP(a2,f:f,0)),false,true) and add this column into the array formula, but I am hopeful that there's a way to solve this without adding auxiliary fields.
Any tips will be very helpul!
Many thanks