SumIF or Vlookup?

Raven26

New Member
Joined
Oct 10, 2006
Messages
37
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
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,118,101
Messages
5,570,217
Members
412,310
Latest member
ForceFollower
Top