I am looking for the formula that will total the amounts of column B based on
Column A Matching Cell A10.

Col A B
Row 1: Red 10
Row 2: Blue 23
Row 3: Red 17
Row 4: Green 19

Row10: Red _____ (This should be 27)

The below formula only gives the result of 10... how to I get the total of
all numbers whose match the word "Red"?

=INDEX($A$1:$B$7,SMALL(IF($A$1:$A$4=$A$10,ROW($A$1 :$A$4)),ROW(1:1)),2)

Thank you in advance,
Joe