Help with scenario

All:

Have a scenario:

Have 6 columns that are dimensional readouts. The tolerance for each is +/- 4.

If the value in each cell exceeds +/- 4, is there a way to tally the number of occurences, and place that value in the 7th column?

Am stumped on how to accomplish this.

Thanks

Paul

No, that will not work as I don't need the values themselves to SUM, but rather need the # of occurences summed.

So, if there were 4 out of 6 columns "out of tolerance", than I would need a "4" to appear in column 7; if 1 out of 6 bad, than "1" to appear, etc...

Thanks!

Paul