Help with SUMIF

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

I need some help with the simple use of SUMIF. I have searched and spent hours trying to get chat gpt to help, but still no luck. I am new to using spills so I am sure I am missing something small.

I have a tab in excel called assets, it pulls all the active characters assets using “=EVEONLINE.CHARACTER_ASSETS()” and puts them in column A, I have in column B a count of the quantity using”=A2#.quantity” . I have a new tab for Reactions and a list of all the moon goo. I am trying to use SUMIF to match the asset name from the spill in the assets sheet which matched the list in the reactions sheet, and when it matches sum the quantity.

With a simple SUMIF “=SUMIF(Assets!A:A,A2,Assets!B:B)” get a zero value, and there are result for the goo it is linking. I have spent hours and tried all sorts of stuff from gpt using long formulas, confusing script with LET, but I just can’t get it to sum the matching count value.

I tried using the spill to another column with id, which gives the same name.

Hopefully this makes sense.

Anyone able to help ?

2

Is it because in column A of Assets, it’s not actually the name of the item but the data card?

What I would do is the following:

  1. Get your assets using your above formula to reside in column A.

  2. Then, select ‘type’ from the card. The icon should look like an aeroplane.

  3. From column B, select the ‘id’. This will sit in column C.

  4. From column B, select ‘name’. This will sit in column D.

  5. From column A, select ‘quantity’. This will sit in column E.

The reason i suggest getting ‘id’ is that it’s common practice to reference against IDs rather than names.

You can streamline the above process, adding the method at the end of the formula. So you could go straight to the id values with this:

=EVEONLINE.CHARACTER_ASSETS().type.id

or the quantities would be:

=EVEONLINE.CHARACTER_ASSETS().quantity