Formula to lookup stock and calculate dividends

[NeoSez]

I am trying to figure out how to only look up ABC stock to calculate dividends only.
Column B: indicates whether it is DIV, BUY, SELL
Column C: name of stock (ABC stock)
Column J: $ amount
R3 = the lookup value aka stock
How do I change this current formula to only include DIV for ABC stock?

=SUM(VLOOKUP(R3,C2:J44,{8},1))

 

[bebo021999]

May be.
Combine column B&C, then track to row that matchs "DIV" & ABC stock, then get corresponding value in column J

=lookup(2,1/($B$2:$B$44&$C$2:$C$44="DIV"&R3),$J$2:$J$44)

LOOKUP function will get the last match, in case there are more than 1 match.
if you want to get the first match, try INDEX(MATCH instead

 

[Legacy 143009]

It looks like a simple SUMIFS issue. Or did I get it wrong?

=SUMIFS(J2:J44,B2:B44,"DIV",C2:C44,$R$3)

 

[NeoSez]

It looks like a simple SUMIFS issue. Or did I get it wrong?

=SUMIFS(J2:J44,B2:B44,"DIV",C2:C44,$R$3)

@Flashbond DING DING DING! You got it right! Thank you so much.

 

[NeoSez]

May be.
Combine column B&C, then track to row that matchs "DIV" & ABC stock, then get corresponding value in column J

=lookup(2,1/($B$2:$B$44&$C$2:$C$44="DIV"&R3),$J$2:$J$44)

LOOKUP function will get the last match, in case there are more than 1 match.
if you want to get the first match, try INDEX(MATCH instead

Thank you for your response @bebi021999. However, I found Flashbond's solution worked perfect for my needs.

 

[Legacy 143009]

@Flashbond DING DING DING! You got it right! Thank you so much.

Glad it did help Thanks for the feedback