formula ?
 

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.

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.

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.