Formula Help .. please

[al619]

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 A1114).
Basically if the above section is marked with a "x", I would like the sq.
ft. to show up.
Thank you in advance,
al619

 

[Lars-Åke Aspelin]

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 A1114).
Basically if the above section is marked with a "x", I would like the sq.
ft. to show up.
Thank you in advance,
al619

In cell B11, try the following formula:

=IF(C4="x",$B4,"")

Copy this to the right to C1111 and then copy down B1111 to
B1214

Hope this helps / Lars-Åke