SumIF or Vlookup?

[Raven26]

I want to create a summary of account Balances. I want it to look like the example below. A formula to Sum all Amounts from Column F for Account Code "A" (in Column B)


A_______B_______C_________D_________E_____F
Date___Code#_Description____Debit___ Credit_____Total
10-Mar___J____Account J_____$64.08 ($64.08)
4-Mar____A____Account A ___________$54.00______$54.00
2-Mar____K____Account K ___________$11.80______$11.80
23-Feb___A____Account A ___________ $19.59______$19.59

SUMMARY :
J______$(64.08)
A______$73.59
K______$11.80

 

[Aladin Akyurek]

A formula with SumIf is the right approach to take...

 

[Raven26]

Not sure how to create the sumif formula.

 

[Aladin Akyurek]

Not sure how to create the sumif formula.

Try...

=SUMIF($B$2:$B$5,K2,$F$2:$F$5)

where K2 houses an account code like A or J.

 

[Raven26]

That works perfectly. Thanks!