Help with formula

  • Thread starter Thread starter nander
  • Start date Start date
N

nander

I am working with a income statement.
In column A are the account classifications, column B identifies th
account as fixed or variable expense, column C is the value. Wha
formula can I use that I can total the Fixed and Variable costs in tw
different cells based on what is in column B so that if I change th
letter in column B to either V or F the total Fixed or Variable amoun
will change accordingly

A B C

Sales 10,000
Sales Returns V 500

Cost of Goods V 7000
Freight In F 250
 
A couple of Sumif formulas should do what you ask.

However, I don't know what you want to do with C1 (Sales).
Add it to "V"?
Add it to "F"?
Add it to both?

This will add it to both:
Enter this in C5:
="V="&SUM(C1,SUMIF(B2:B4,"V",C2:C4))
And this in C6:
="F="&SUM(C1,SUMIF(B2:B4,"F",C2:C4))
 
Actually, after reading this again, I believe that maybe "V" and "F" should
be deducted from C1 (Sales).
If that's the case, try these:

="V="&C1-SUMIF(B2:B4,"V",C2:C4)

="F="&C1-SUMIF(B2:B4,"f",C2:C4)
 
Back
Top