I am creating a "Table of Measurements" for a moving company in Excel, and they require that in the "# of pieces" cells that a number "1" or a similar character be placed in the cell rather than a "2" for two pieces or a "3" for three pieces, etc. So if there are 4 pieces, the cell would have "1111" in it. It's really a Tick Sheet to determine how much space will be taken up by each item on the moving truck. This "tick value," must then be multiplied by the cube (square footage) that is on file for each item.

For example, a bookcase is 20 cubic feet, so if I have 2 bookcases that would be (obviously) 40 cubic feet.

My dilemma is that in the cells where the "1's" or each tick goes, I need to have the total Sq. Ft. calculate this from the amount of "1's" or "tick marks" in the corresponding cell. As for above, if I place two 1's in the # of pieces cell, to Excel that looks like "11," and I need this to show up in the total cell as 40, because the cubic footage is 20.

Get it?

I seem to be stuck here... help!