Thank you for all of your help with this.
So, I named the range of data and then I named the table. I then copied your formula and changed formula to reflect my table and range name, but it's not working for me.
I get the dreaded message "There's a problem with this formula..." I have attached a screen shot of the message.
What am I doing wrong? I have no doubt it's user error.