That worked like a charm! Thank you so much.

You're welcome.

One more question--why did I have to do the Control-Shift-Enter to make
it work?

That is how Excel knows to treat the ranges inside the function as arrays, where each element is
evaluated seperately, rather than just as a range, where (often) all elements are handled at once.
For more on array formulas, visit

http://www.cpearson.com/excel/array.htm

HTH,
Bernie
MS Excel MVP