Hi,
I am trying to create a summary section at the top of a sheet I am working on that has a drop-down list via data validation to change the relevant table that is showing the totals (in this case the month in question). I want the sumif function to apply to the relevant table relating to what has been selected in the drop-down list.
As mentioned, each table is a month of the year (and, is called Jan, Feb Mar, etc) and in each table, I have several items with a rating against them (High, Medium, Low) and a corresponding £amount.
I want to be able to select the relevant month from the drop-down list and the totals for High, Medium and Low to show for the selected month/table.
I thought this might be an indexing thing but can't quite figure it out.
Thanks!
I am trying to create a summary section at the top of a sheet I am working on that has a drop-down list via data validation to change the relevant table that is showing the totals (in this case the month in question). I want the sumif function to apply to the relevant table relating to what has been selected in the drop-down list.
As mentioned, each table is a month of the year (and, is called Jan, Feb Mar, etc) and in each table, I have several items with a rating against them (High, Medium, Low) and a corresponding £amount.
I want to be able to select the relevant month from the drop-down list and the totals for High, Medium and Low to show for the selected month/table.
I thought this might be an indexing thing but can't quite figure it out.
Thanks!
