It should work fine. 2 possibilities happening over there
1. You used entire col ranges. You can't for sumproduct (not in xl2003 anyway)
2. If 1's not it, then its your data. You need to check your source data in
cols A and B. Clear up all #NUM error values that's in there.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"NWO" wrote:
Now I'm getting a #NUM after entering the formula. I still appreciate your
help. Help!