Forum Discussion
farmlife
May 14, 2024Copper Contributor
Excel data
Hello, I am not extremely advanced when it comes to using excel. I have a table that lists all of our land owners and their corresponding field names. I made another sheet with a data vali...
- May 14, 2024
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)
farmlife
May 15, 2024Copper Contributor
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.