"Mel" wrote:

New at this hope this makes sense:

I have rows of data that include entering demographics, 6 columns indicate
race, 2 columns gender, six age range columns and a total participant column.

What formula would add the numbers in each of the demographics and insure
that the different ranges equal each other and the total participants for
each row.
ie.
col. I J K L M N O P Q R S T
U V
WB AOHU Male Female <5 5-12 13-18 19-49 50-64 65+ Total
row 55 4 27 28 59
59
It would let the person know the Gender doesn't equal the other totals.
Mel