excel lookup and sum

I am trying to search for a cell in vagByAgetn tab and for all matchs in VAGHOptions tab sum the column B.
See formual in column C of VAGbyAgent. I tried this
=SUMIF(VAGOptions!A:A,A3,INDEX(VAGOptions!B:B,,MATCH(A3,VAGOptions!A:A,0))) but get ref error

I tried this
=SUMIF(VAGOptions!A:A,A4,INDEX(VAGOptions!B:B,MATCH(A4,VAGOptions!A:A,0)))
but for VAG_CS_L1_Shelton_Voice_IWS i get 9 when it should be 2+16+8 (see b40:b42 on VAGOptions tabl

thanks
pcombAsked:
Who is Participating?
 
NorieVBA ExpertCommented:
Isn't it just this?

=SUMIF(VAGOptions!A:A,A3,VAGOptions!B:B)

Or am I missing something?
0
 
pcombAuthor Commented:
0
 
pcombAuthor Commented:
norie no thank I I think I was getting confused
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.