I'm trying to avoid putting too many columns in a file I'm working on. By the way, I should have mentioned that I'm using 2007.

Your suggestion worked (although, in Excel 2007, the "Define Name" command is in the "Formulas" tab), but I would also like to be able to sum only the terms that I choose; i.e., only the number of "A"s, "B"s or other terms. Is there any way to use the sum function (or another function) to do this?

Thanks