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?

Thank you.