Hi Everyone,
I need a forumula to place in column I , that will look at the asset under column H and sum up all the matching amounts from table 1
So for example: Table 2 (I4) coloured in orange, should scan table 1 and sum all the amounts for XRP. This should total 10600
I think this will involve vlookup, match or Index somehow.
I need this formula, because the tables in my real excel document is huge. It would take a while to sum everything up individually.
So this foumula is ideally should be scalable to large tables.
Thanks in advance!
Bookmarks