I'm stuck using XL 2000 and so can't figure out why this formula is not
calculating. D5:D57 are expense codes, formatted as General. These expense
codes are 5 digits long, but are NOT formatted as numbers. D121 is an
expense code, formatted as General. G5:G57 are dollar values, formatted as
Accounting.

The value returned should be $1,203,201 but $0 is being returned.

Does XL 2000 have a SUMPRODUCT limitation that I'm unaware of?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.