View Single Post
  #1   Report Post  
RagDyer
 
Posts: n/a
Default add cells conditionaly not in continuous row or column

Try this:

=B8+MIN(C7,0)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"loganinc6" wrote in message
...
I need to add two cells not in a continuous row or column, say B8 and C7,

but
only if the value in C7 is less than zero. If value in C7 is more than

zero
need the cell to equal the value in B8