Murph

Try this. It will only work if the value that you place in I3 to M3 on
sheet1 is a numeric value. Also this formula will display a blank if you have
eiter zero or more than one cells with value

=IF(COUNT(Sheet1!I3:N3)<1,"",MIN(Sheet1!I3:N3))

Alok Joshi

"Murph" wrote:

trying to copy the value from I3 - M3 from sheet 1 to cell N3 on sheet 2.

I am not trying to add the values together, there will be only one cell
filled in for I3-M3, (I3,J3,k3,l3,m3) and I want that value to be placed in
cell N3 on sheet 2.

Thanks again for all your help.