Adding it all up

I'm clearly overwrought.

Indeed you are, Uncle Ken, and I think you should have reviewed your material more carefully before sending it to all the board members.  I caught a few minor errors, a sentence fragment in particular, but the lights data has me befuddled.  Something doesn't quite add up.

The first block of data for the owners looks okay.  Adding up the numbers for multicolored, white only, and no opinion equals 389, the number of owners.  The other two groups are way out of whack when you add their numbers.   If there are 173 renters why does the total of multicolored/white only/no opinion equal 417?   Same thing with the combined group; the numbers are screwy.  How can there be a combined total of 20 for "no opinion" when owners and renters have 63 and 83, respectively?  And look at the "white only" numbers for the combined group; it looks like you forgot the owners.

Now I'm getting overwrought.   I don't want to be the nitpicking asshole (again!) but I don't want to see you look like a chump in front of the board and spend all of your allotted time explaining and correcting yourself.  You are on your own holy mission and deserve success after all of your efforts.

If I missed something or completely misunderstood the nature of the data, let me apologize up front.  The Old Dog regrets the error.

Finally, does "no opinion" mean "no response?"  I don't think they are the same thing.  This whole survey thing seems like a big can of worms to me, especially if you try to factor in units with more than one occupant.  Kind of reminds me of the electoral college; how do you split the vote?  Good luck tomorrow.