Can you combine SUMIF & MID functions?

J

Jana

I want to sum the values in ColB, if the 3rd & 4th digits
in ColA = 33, so the result of the formula would = 20. I
can't seem to get the formula to work using both the
SUMIF and MID functions together. Can you tell me how to
do this? Maybe there is another function I should be
using.

ColA ColB
R1 AI5300G 4
R2 AI3300G 5
R3 AI4100G 6
R4 AI3300G 7
R5 AI3300G 8
 
F

Frank Kabel

Hi
try
=SUMPRODUCT(--(MID(A1:A100,3,2)="33"),B1:B100)

or try
=SUMIF(A1:A100,"??33*",B1:B100)
 
Top