Hello, thank you for taking to the time. I have searched, but the answers I found incorrectly assumes I will be making a selection from the list. I would like to avoid using VBA if possible because I want to be able to make duplicates of this spreadsheet, still have the formulas work, without worrying about whether the VBA and macros were disabled on another Office 13 installation.
The spreadsheet is as follows:
Column AV contains any numeric values of : $0 ~ $10,000.
Column A contains one category of : Fixed income or Variable income or Defrayment
This I know works and produces the result I desire...
=sum(sumifs(AV2:AV50, A2:A50, {"Fixed Income", "Variable Income", "Defrayment"} ) )
... but, rather than "statically" typing the string array, I want the array to be more dynamic by referencing a manually populated list and not requiring an item to be selected.
A1 would contain the manually populated list. To create this list, I used the Data Validation function in the Data menu and wrote in the source field : Fixed Income, Variable Income, Defrayment .
Something like this.
=sum(sumifs(AV2:AV50, A2:A50, {A1} ) )
I am guessing there is a function I do not understand yet to achieve my goal.
Can I use a manually populated list as a string array for sumifs criteria?
Or maybe I should avoid the manually populated list and simply enter a string array in A1? such as.. ={"Fixed Income", "Variable Income", "Defrayment"} .. but this does not work either.
The spreadsheet is as follows:
Column AV contains any numeric values of : $0 ~ $10,000.
Column A contains one category of : Fixed income or Variable income or Defrayment
This I know works and produces the result I desire...
=sum(sumifs(AV2:AV50, A2:A50, {"Fixed Income", "Variable Income", "Defrayment"} ) )
... but, rather than "statically" typing the string array, I want the array to be more dynamic by referencing a manually populated list and not requiring an item to be selected.
A1 would contain the manually populated list. To create this list, I used the Data Validation function in the Data menu and wrote in the source field : Fixed Income, Variable Income, Defrayment .
Something like this.
=sum(sumifs(AV2:AV50, A2:A50, {A1} ) )
I am guessing there is a function I do not understand yet to achieve my goal.
Can I use a manually populated list as a string array for sumifs criteria?
Or maybe I should avoid the manually populated list and simply enter a string array in A1? such as.. ={"Fixed Income", "Variable Income", "Defrayment"} .. but this does not work either.
