#Name? Error in cell by SUMing vLookUp

[RapchikM]

Hello
I get #Name? Error in cell by SUMing vLookUp

I want to sum up values of column Range where in Range value 500 is displayed and want to sumup its 3rd column
in E14 i've typed Following formula

=SUM(vlookup,C14,J2:L15,3,0)

C14 = 500

Range From J2:L15
Cell J4 = 500 Cell L4 = 8
Cell J11 =500 Cell L11 = Empty
Cell J12 =500 Cell L12 = 20

want to sum up values of col L if in ColJ Value contained 500. To get value in E14 as 28

RapchikM

 

[Fluff]

You cannot use vlookup for that try

=sumifs(L:L,J:J,500)

 

[RapchikM]

You cannot use vlookup for that try

Oh OK

Thank you very much sir

RapchikM

 

[jtakw]

Hi,

Also, using your cell reference:

=SUMIF(J4:J12,C14,L4:L12)

 

[Fluff]

Thank you very much sir

You're welcome & thanks for the feedback.