Hi everyone,
i need to acheive the following but i'm not sure how to do it. i have a cell
(K49), the cell needs to collect specific data from a range ( D7:D32 ) on the
same worksheet. it needs to look in the range and if the cell value is CNC,
then add the figure form the same row in column E. Example:

D E F
glass £200 26 August 05
metal £650 26 August 05
wood £300 26 August 05
CNC £1000 26 August 05


my cell value would be £1000 as it found CNC in the range in column d and
added the value in column E. ( i hope this makes sense!!)

if anypne could guide me in the right direction, it would be greatly
appreciated.


Regards,

Nigel