|I'm not sure if this is what you are looking for, but you could use Named Ranges for your regions and then refer to the individual cells in the range. For example, if you named B47:B49 as Region1, then this formula should give you the total number of instances of all of the values in B47:B49 found in E2:E26:|
This is an Array formula and must be enter with Ctrl-Shift-Enter every time you edit it.
If you want to put a Region's name in a cell, such as A1, you could then refer to that Named Range with the INDIRECT function.
e.g. if you put Region1 in A1, this formula would be equivalent to the one above.
This, of course is also an array formula.
BTW..If you are using SUM, you don't need the Addition Operator within the parenthesis, you can just use a comma. If you want to use the Addition Operator then you don't need the SUM function. It is redundant.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03