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
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
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