So just when I thought I had all the schedule stuff figured out...
I am consolidating all the similar windows together by using the SUM function in the Marks database headers. I use the =COUNT formula to display quantity. And I divide by that quantity (/A4, the cell which the +COUNT formula appears) in the formula for overall height, overall width, and elevation.
The quantities show up correctly. The dimensions are right if the quantity is 1, but half what they should be when the quantity is 2, and a quarter of what they should be when the quantity is 4.
I did this in the door schedule and didn't have a problem. What am I overlooking here?