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

Look at the Subtotal function, or a Pivot Table.

Regards,
Fred

"dh1069" wrote in message
...
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

"Fred Smith" wrote:

Look at the Subtotal function, or a Pivot Table.

Regards,
Fred

"dh1069" wrote in message
...
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



.