Help Sorting Data

  • Thread starter Thread starter dh1069
  • Start date Start date
D

dh1069

I have the following columns of information and need to setup a formula that
will give me the total by location, by dept, then by g/l account.

DEPT G/L Account Bakersfield
Fleet 42101 $10.00
Fleet 42101 $125.00
S & D 42101 $35.00
MEM 42199 $10.00
Fleet 23099 $1,000.00

I will then point to the cell containing the final cost number.

Example: Bakersfield, Department Fleet, G/L Account 42101
$1,145
 
Hi Fred,

Subtotal doesn't accomplish what I need and I am not too familiar with Pivot
table, can you give me a little more detail?

Thanks,
David
 
Back
Top