vlookup and sumif

[arun198322654]

Hi Guys

As in vlookup formula we all know that it will lookup the matching criteria and give the output from the range. Now i am facing the difficulty that their are two similar criteria in the table and i want sum of those . For further details i am attaching the excel sheet.

Thanks in advance

 

[Khalid NGO]

Hi Arun,
Try this:

=SUMIF(B5:B9,B14,C5:C9)

Regards,

 

[Ramesh]

I agree with Khalid, in Cell C14, write the formula using SUMIF as follows :

=SUMIF($B$5:$B$9,B14,$C$5:$C$9)

 

[jayalaxmi]

this one use CSE

=SUM(IF($B$5:$B$9=B5,$C$5:$C$9,0))

 

[Syedali]

PFA

 

[jayalaxmi]

=SUMPRODUCT((B5:B9=B14)*(C5:C9))

 

[arun198322654]

thanks a lot