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
Taking formula to text 3
can i avoid repeating rows when adding calculated item in pivot ta 4
Help with IF Functions 4
Listing variable names for 3 greatest values in a column? 3
Count Intervals of Filtered TEXT values in Column and Return Count across a Row 9
Matrix Math using LOOKUP inside Array {} Function 4
Sumproduct or Countif question --- multiple criteria 5

Top