I have a formula that I usually use for picking numbers,
but it`s not working when I try to pick text. Isn`t the
array formula useful for picking up text?

{=SUM(IF(ABKunder!$B$9:$B$910=$F2;ABKunder!
$D$9:$D$910;0);0)}

Does anyone have a clue here.

Help is appreciated

Gunnar