SOLVED

Help with a formular

%3CLINGO-SUB%20id%3D%22lingo-sub-2101676%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20formular%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2101676%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everybody%2C%20need%20some%20help%20here.%3C%2FP%3E%3CP%3EIm%20building%20a%20summary%20of%20stock%20I%20have%20bought%20over%20a%20year.%3C%2FP%3E%3CP%3EI%20have%20various%20colums%20en%20rows.%3C%2FP%3E%3CP%3EIn%20Colum%20B%20there%20are%20the%20id's%20that%20matches%20to%20a%20sertain%20stock%3C%2FP%3E%3CP%3EIn%20Colum%20I%20there%20are%20the%20number%20of%20shares%20that%26nbsp%3B%3CSPAN%3Eare%20purchased.%20They%20can%20spread%20over%20several%20rows.%20Every%20row%20means%20a%20new%20buy%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIm%20using%20the%20X.loopup%20statement%20(in%20formular%20is%20used%20X.zoeken%20that%20is%20the%20translation%20to%20dutch).%20Sow%20far%20it%20is%201%20perticular%20share%20I%20can%20manage%20the%20formular.%20But%20if%20there%20are%20multiple%20lines%20of%20the%20same%20share%20I%20always%20get%20the%20result%20of%20the%20first%20line%20from%20that%20perticular%20share.%20Im%20this%20case%20I%20have%205%20lines%20to%20count%20(%20in%20numbers%20of%20shares%20and%20value)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECan%20anyone%20help%20me%20get%20the%20right%20formular%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20ahead%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMarco%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2101676%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2101761%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formular%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2101761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F943397%22%20target%3D%22_blank%22%3E%40Marco100964%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EIf%20I%20understand%20you%20correctly%2C%20you%20need%20SUMIFS%20function.%3C%2FP%3E%3CP%3Esee%20attachment%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everybody, need some help here.

Im building a summary of stock I have bought over a year.

I have various colums en rows.

In Colum B there are the id's that matches to a sertain stock

In Colum I there are the number of shares that are purchased. They can spread over several rows. Every row means a new buy

 

Im using the X.loopup statement (in formular is used X.zoeken that is the translation to dutch). Sow far it is 1 perticular share I can manage the formular. But if there are multiple lines of the same share I always get the result of the first line from that perticular share. Im this case I have 5 lines to count ( in numbers of shares and value)

 

Can anyone help me get the right formular?

 

Thanks ahead

 

Marco

2 Replies
Best Response confirmed by Marco100964 (New Contributor)
Solution

@Marco100964 ,

If I understand you correctly, you need SUMIFS function.

see attachment

@Boriana Petrova 

 

Yes thank you!

 

Marco