formula ?

[Guest]

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.

 

[Trevor Shuttleworth]

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

 

[Guest]

Thanks Trevor it looks like it is going to work.

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