That long formula worked. I know I have long column header names, but for our purposes, it works. And the reason for all the blank rows is that I knew I would be adding multiple lines of data just a soon as I got the formulas right, though, of course, you are right about the table expanding to accommodate new rows, just kind of did it out of habit.
Thanks for your help...