Forum Discussion
Excel data
Let's say your table is named Table1, with columns named Land Owner, Field Name and Acres (among others)
On the other sheet, the data validation drop-down is in B1.
In a cell below it, enter the formula
=FILTER(Table1[[Field Name]:[Acres]], Table1[Land Owner]=B1)
So I would like for it to add up the total acres for this land owner and the total dollar amount.
I was hoping maybe I could total it from the data that came from the filter formula. When I did a Vlookup formula from the other table it only came back with one of the fields populated if that makes sense.
It's hard to tell what is what from your screenshot.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
