Actually the name error was my fault. What I'm getting isn't correct,
however. If I understand the function correctly, OFFSET() allows me to
sum a whole range of numbers, such as columns A thru G, while the
INDEX() just pulls one cell. I need the range because I am adding
monthly numbers to make a YTD number. The formula lets me change the
Month in cell $B$1 and not have to change information in every single
formula.


--
Monte75
------------------------------------------------------------------------
Monte75's Profile: http://www.excelforum.com/member.php...fo&userid=2171
View this thread: http://www.excelforum.com/showthread...hreadid=472789