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 ?