Hlookup with Sumif

[ysherriff]

Hi all, please see below i am trying to sumif an hlookup. Column b is the formula and column a is the lookup and rows d1:l10 is the data table

any help would be appreciated.

 

[Somendra Misra]

Hi,

Not really understood but try below array formula. Confirm with Ctrl+Shift+Enter.

=SUM(HLOOKUP(A2,$E$1:$L$11,ROW(INDIRECT("2:"&COUNT($J$2:$J$11))),0))

Regards,

 

[bosco_yip]

Maybe…….

In B2 copy down :

=SUM(INDEX(E$2:L$10,0,MATCH(A2,E$1:L$1,0)))

Regards

 

[Khalid NGO]

Hi,

I am also not sure what you are looking for...

Try this if you need sum:
=SUMPRODUCT(($E$1:$L$1=A2)*($E$2:$L$10))

And this if you need individuals as mentioned in your cell B2:
=LOOKUP(A2,$E$1:$L$1,$E2:$L2)

Regards,