Re: sum column while excluding corresponding text values?

Thanks everyone!! That last formula suggestion worked out great!

One more question just out of curiosity. In another posting I asked
for help with counting values in correlation to a column of text. A
formula was suggested and it worked. However, that was at the office
and when I opened the spread*** at home I'm getting a #DIV/0 error.
At work I use Office XP but at home I have Office 2000. Could the
difference in these versions be the reason the formula doesn't work at
home?

Just in case anyone wants to see it, here's the formula I'm referring
to:

=SUMPRODUCT((Queue_User_Routing.csv!$B$2:$B$2000<>"")/COUNTIF(Queue_User_Routing.csv!$B$2:$B$2000,Queue_User_Routing.csv!$B$2:$B$2000&""))


Thanks again to everyone for your assistance and great suggestions.

-Danny

.