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.
|