I am trying to sum all values in a cell given certain criteria.
=AGGREGATE(9,4,INDEX(DATA RANGE,0,MATCH(YEAR,YEAR NUMBER COLUMNS,0))/((CODE COLUMN=CODE NUMBER)*(COUNTRY COLUMN=COUNTRY)))
This is the illustrative function i am using.
The three criteria are: Code (row), Country (row), and Year (column)
I want the function to automatically change as i change any of these criteria in a drop down list.
Does not have to specifically be this function. I am trying to sum all numbers given these criteria.
Thanks!
Bookmarks