Thanks Trevor it looks like it is going to work.

"Trevor Shuttleworth" wrote:

If it makes sense, then this too will make sense because it will mean I
understood the question:

Something like:

=SUM(A1:E1)+IF(G1="check",0,F1)

So this adds cells A1 to E1; if cell G1 has "check" in it it adds nothing to
the sum, otherwise it adds F1

Regards

Trevor


"Rj" wrote in message
...
How can I not have a number not add of a cell is checked but if it is not
checked it will be added with the rest of the cells?
Hope this makes sence.