Formula Help .. please
 

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

Formula Help .. please
 

On Tue, 16 Dec 2008 12:51:01 -0800, al619
wrote:

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

In cell B11, try the following formula:

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

Copy this to the right to C11:D11 and then copy down B11:D11 to
B12:D14

Hope this helps / Lars-Åke