Many thanks for all the quick replies.,

This method seemed the the quickest and worked perfectly.



"Dav" wrote:


If the values are truly entered as numbers they will sum in the sum
expression. They have been returned by the lookup as text, which might
mean that they are text in the first place and hence are excluded from
the calculation.

Your options are to turn them into values (the best option)

Or for expediency if you enter the floowing as an array presseing ctrl
shift enter after entering it, it should be a workround

=SUM(E8:E12*1)

E8:E12 needs to be changed to the appropriate range of data

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=518133