Totaling Categories - Monthly and YTD

[Jackson]

Hi,

My boss has assigned me a task. He has dropped a workbook full of
monthly accounting worksheets on my desk and wants me to total the
monthly entries by categories. These categories are stored in a list on
an individual worksheet and are entered into each monthly worksheet in
column D. They range from advertising to supplies to taxes and are
several hundred individual entries per month.

I will also need YTD totals by category on a running sheet..

Any help would be appreciated because I know nothing about excel and
google didn't help

Thank you.

Sherrie

 

[Don Guillett]

Hi,



My boss has assigned me a task. He has dropped a workbook full of

monthly accounting worksheets on my desk and wants me to total the

monthly entries by categories. These categories are stored in a list on

an individual worksheet and are entered into each monthly worksheet in

column D. They range from advertising to supplies to taxes and are

several hundred individual entries per month.



I will also need YTD totals by category on a running sheet..



Any help would be appreciated because I know nothing about excel and

google didn't help



Thank you.



Sherrie

If the boss knew you didn't know excel, the boss should have hired one of us to do it instead of asking you.

 

[Jackson]

Thanks so much for your informative reply.

A.H.