I have an Excel 2003 workbook with multiple named ranges. They all begin with
LF followed by the specific name (LFData, LFStuff, LFFoot, etc.) and are
found on various sheets in the workbook. Is it possible to create a function
to gather all of the LF named ranges and give me a total? I don't want to
individually put the named ranges in, I want Excel to do it for me. Based on
my example above it would find for me LFName, LFStuff, LFFoot and show me the
total of all three of these. However, I have more like 20 of these named
ranges.

If LFData = 5 and LFStuff = 1 and LFFoot = 2 the formula would return the
answer 8.

Thanks for the help. : )