One way:

=SUMPRODUCT((A1:A4="AG")+(A1:A4="AD"),B1:B4)

In article ,
Barbara 1 <Barbara wrote:

What equation would I use to be able to sum a column based on multiple
criteria from another column? i.e..... sum if AG or AG

AG 50.00 Total
AD 25.00 75.00
DE 10.00
SG 45.00