Try this...

=SUMIF(P6:P110,"usd",X6:X110)

Windy