A B C D E

room name sq. ft tile wood carpet
4 living room 125 x
5 dining room 135 x
6 bedroom 110 x
7 bathroom 68 x
8
9
10 tile wood carpet
11 living room 125
12 dining room 135
13 bedroom 110
14 bathroom 68

Hello all,
The above section is the data. I would like the end results to be what
happens below (section A11:D14).
Basically if the above section is marked with a "x", I would like the sq.
ft. to show up.
Thank you in advance,
al619