Thanks for your help

I changed B9 to 6000:6099

and the formula to =-GLAMT("Y",RNGMERGE($B10,D$6))

and everything worked.
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.