Hello,
I have a database (sample attached) and I'd like to pull data from it onto a "summary statement" in a new tab. The summary statement will include the same criteria as the database fields. The database is as follows:
Property # (Column A)
Account # (Column B)
Date (Columns C-E, and it will continue over as time goes on)
Actual Data (C2:E7, in this example)
The Summary Statement will still have all the Accounts listed as in the database, and it will have the Dates (years, or months) as well. The catch is that I would like to have a section where the user/manager could input 1 or multiple Properties as a Filter, and the Summary Statement would be populated with the Actual Data based on which Properties are inputted.
I am looking for a formula that achieves this.
In the attachment, I can get close coming at it from two different angles, but I can't get it right:
Formula 1 - Filters the data together by Account and whatever Properties are listed in the Property Filter (A2:A11). BUT, I only know how this works with one sum column, and in this example it is 2013 (not including 2014 or 2015) from the Database. Uses SumProduct and IsNumber.
Formula 2 - Allows user to filter data for any Property, Account, and under the correct Date on the summary statement; BUT, only 1 Property can be selected in this formula. Uses SumProduct.
It would be great if the second formula can integrate the filter array allowing for the selection of multiple Properties as Formula 1 does. But catching the data for all rows/years. Essentially need to "combine" both formulas into one!
Anyone's assistance on this is much appreciated and thank you in advance. Happy new year!
Bookmarks