Cell formula, picking Text

  • Thread starter Thread starter Gunnar
  • Start date Start date
G

Gunnar

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