SUMIF, How to ... ?

[Bob]

Goal: If column A identifies the "Authorization Code" and
contains several cells beginning with "3BM" (w/o quotes),
then sum their corresponding cells from column D, "Actual
Costs."

Example:
Column A cells: A2=2SW, A3=3BM, A4=3SW, A5=3BM, A6=5SC,
A7=3BM

Column D cells:
D2= $34, D3=$24, D4=$52, D5=$62, D6=$37, D7=$10

The result for Authorization Code 3BM should be $96 (i.e.,
the sum of D3, D5 and D7).

Note: I failed with various formula combinations using
VLOOKUP, INDEX AND LEFT.

Thanks for any and all assistance.

 

[Rafael Ortiz]

Try this:

=SUMIF($A$2:$A$7,"3BM",$D$2:$D$7)

Adjust criteria as needed to find other sums.

MRO

 

[Alan Beban]

Or substitute 3BM* for 3BM if the authorization codes might be 3BMx,
3BMy, etc.

Alan Beban

 

[Bob]

Thank you Mr. Beban and Mr. Ortiz.
The formula =SUMPRODUCT((LEFT(A2:A7,3)="3BM")*(D27))gave
me the desired result.