Formula Help

  • Thread starter Thread starter meganblf
  • Start date Start date
M

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
 
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?
 
Or not.. =IF(F2="X",B2+C2)

Sean Timmons said:
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?
Click to expand...
 
Back
Top