Cell formula, picking Text
 

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

Cell formula, picking Text
 

This array formulae works for me even if the reference
(A12) is text (Using Excel XP)

=SUM(IF(Sheet1!$A$9:$A$20=$A12,Sheet1!$B$9:$B$20,0 ))

Abdul Salam


-----Original Message-----
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
.