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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

daverage worksheet function 1
Automating a computation process 3
what's wrong with this function? 0
Filter or Query Between Worksheet 1
Help with IF Functions 4
Combining sumIF statements with other functions? 2
can i avoid repeating rows when adding calculated item in pivot ta 4
Formula until condition met 4

Top