I am using an array formula to collect numeric data. I would like to use an
array formula to collect text data. My data base has text and numeric. When
I try to collect the text data it comes back with a "0". Formula that I am
using is:

=(SUM((SP_DATA!$B$10:$B$2002=A9)*(SP_DATA!$C$10:$C $2002=B9)*(SP_DATA!$D$10:$D$2002=C9)*(SP_DATA!$F$1 0:$F$2002=E9)*(SP_DATA!$G$10:$G$2002=D9)*SP_DATA!$ AH$10:$AH$2002))

AH10:AM2002 contains text.