Validation for sum
I have a row that contains about 26 cells and holds percentages. I want an
error message to display when the sum of those 26 cells goes over 100%. I
didn't know how to do this so based on some suggestions I found in the
archives here I first created a total cell at the end of the row and then
used this formula in the 26 cells of the row =BQ16100.
I feel stupid cause I'm sure this is so easy it will bite me on the nose.
Can someone help me. Thanks!
|