Totaling Categories - Monthly and YTD
 

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

Totaling Categories - Monthly and YTD
 

On Thursday, September 6, 2012 12:38:07 PM UTC-5, Jackson wrote:
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.

Totaling Categories - Monthly and YTD
 

Thanks so much for your informative reply.

A.H.


Don Guillett wrote:
On Thursday, September 6, 2012 12:38:07 PM UTC-5, Jackson wrote:
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.