Jan 27 2021 04:02 AM
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
Jan 27 2021 04:30 AM
SolutionJan 27 2021 04:30 AM
SolutionIf I understand you correctly, you need SUMIFS function.
see attachment