Array Formulas working with Filters
Posted on 2012-03-13
Hello. I am trying to add an Array Formula to a spreadsheet that will work if a user then filters by a specific Field. e.g in column A we have countries. At top of spreadsheet I have Array formula for total.
when user selects filter to show only France (list in column could be UK, Spain France etc) I want to see the total Change to show only array result for France not all data...
Thought best way was to add an If statement to the Array but for this I need to know in a specific field what the user has selected...
Example Col A Region, Col B is Units Sold and Col C is the Unit price.
Running array on Column B*Column C by all rows in data set wish to know the filtered total not just the grand total.