In my Christmas list, I am logging what the toy is and for each toy, what kind of batteries that it takes.
Then, I am trying to reference how many of each type of battery that I will need in a summary table, like this:
So, I’m trying to do something like “
Get the sum of the batteries where the column name in Toys equals thisRow.[Battery Type]”.
My formula looks like this:
=Toys.Lookup(thisRow.[Battery Type], CurrentValue > 0).Sum()
But I get a “
Wrong Argument Type” error.
Can you please give me some guidance on this?