Formula Help

[meganblf]

I have created a spreadsheet that we are using to prepare 2 different tax
returns. The spread sheet contains information on properties with 4 possible
values. We are also trying to allocate these properties into two different
trusts. I don't want to split up the information as it all relates to each
other. It has been along time since I have worked with formulas in excell.
Could anyone help me prepare a formula.

Example:
a b c d
e f g
1 01 Value 1 O1 Value 2 09 Value 1 09 Value 2
Trust 1 Trust2
2 property 1 10000
X
3 Property 1
20000
4 Property 2 10000
x

What I want is a formula if F2=X then add B2 or C2

 

[Sean Timmons]

Is that add B2 and C2?

Presuming you want to sum all of them..

=SUMIF(F:F,"X",B:B) gets B. Same with C for C. If you want to do one row at
a time, then =IF(F2,"X",B2+C2) perhaps?

 

[Sean Timmons]

Or not.. =IF(F2="X",B2+C2)

Is that add B2 and C2?

Presuming you want to sum all of them..

=SUMIF(F:F,"X",B:B) gets B. Same with C for C. If you want to do one row at
a time, then =IF(F2,"X",B2+C2) perhaps?