Max, sorry for being such a pain... correcting the sorce in col C got rid of
the #VALUE! error. That worked.

But now I want to do the same thing for the next column and it is adding the
numbers correctly.

For col BH where I have the formula finding and adding the values on Col C
on the other spreadsheet I get the correct numbers. But when I copy the
formula over ti BI and find/add the numbers on the col D from the other
spreadsheet I get wrong results. Not all the rows have wrong results, the
majority does and the difference between what the number the firmula
calculates and from what the numbers should be are, in the majority of the
cases, -2 or -10... the formula is below I would highly appretiate any help!!

=SUMPRODUCT((ISNUMBER(SEARCH('[HCount.xls]Nov 2008 HC by
Country'!$A$11:$A$590,BG8)))*('[HCount.xls]Nov 2008 HC by
Country'!$A$11:$A$590<""),'[HCount.xls]Nov 2008 HC by Country'!$D$11:$D$590)

"Max" wrote:

.. it brings up a #VALUE! error.
Check & clean up the source range col C for any #VALUE! error(s) somewhere.
Apply and use autofilter on col C to quickly locate and clear up all of
these, and it should work fine.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---