Help with Match

[Eggplant2016]

Here's what I have:
Column A is populated with numbers.
Column be has a unit of measurement (sp, cp, gp or pp)

I want E20 to keep a running total of all of the numbers that are "sp"
E21 to total all the cp, E22 to total the gp etc...

Column B's units of measurement will change. So for example B21 might be cp one day and sp the next. But I still need E20 to recognize all the values of sp and total them. E21 etc doing the same.

Please help!

 

[horrellbt01]

Do you want a count of the values in column A or a sum?

 

[Eggplant2016]

A sum please. Something like this.
Column F is fixed. Columns A, B, And E are variable.

Column A Column B Column E F
5 cp 5 cp
10 sp 25 sp
15 sp 20 gp
20 gp

 

[JumboCactuar]

=SUMIF($B$2:$B$1000,D20,$A$2:$A$1000)

can use "SP" instead of D20

increase the 1000 to whatever or even better use a table and reference column name

 

[horrellbt01]

For E20:=SUMIFS(A:A,B:B,"sp")
For E21:=SUMIFS(A:A,B:B,"cp")
For E22:=SUMIFS(A:A,B:B,"gp")
For E23:=SUMIFS(A:A,B:B,"pp")

 

[Eggplant2016]

Jumbo.....That's perfect! Thanks