- This topic has 1 reply, 1 voice, and was last updated 2 weeks, 1 day ago by .
-
Posts
-
-
In the table below I am trying to sum (separately) trip and Non-Product times (Green and Orange), based on the tonnes (yellow) from each specific locations (in this case the locations in purple). The locations are made available to the drivers via a dropdown and can be anywhere under “Truck19” depending on what time they load (dynamic). Have attempted combinations of SUMIFS and FILTER INDEX MATCH aswell as XLOOKUP INDEX MATCH.
Have seen all the sample you guys have posted, but can’t seem to match my specific requirements.
Any help greatly appreciated.
=FILTER(GE6:GE34,FV6:FV34=INDEX(FT6:GA34,MATCH(“UGW2800”,FT6:GA6)))
-
Not 100% sure I understand what is going on here.
If your INDEX has more than one row and column, you will need INDEX MATCH MATCH instead of INDEX MATCH.
If you are trying to retrieve a column and compare it with your FV6:FV34 column, you can try something like this:
=FILTER(GE6:GE34,FV6:FV34=INDEX(FT6:GA34,0,MATCH("UGW2800",FT6:GA6)))If you want, you can email your example.
Br,
-