How to Combine Cells of Information in Excel

[GT]

Hi,

tried my best to find the answer through the HELP menu and
the knowlege base...but unsucessfull.

I have an expense tracking Excel file, with worksheets for
every months. Each worksheet has the same format. Column A
has a controlled list of expense type (Office Supplies,
Entertainment, Telehpone...etc). Column B has the amount.
Each row is an expense.

I want to create a worksheet with the total expense of the
year, and for each month...and...this a part I can't
figure out...that resumes the total expense for each
categorie of expenses. Bottome line I need, to write a
formula that looks in all the worksheets, for each
category in Column A, take the value in Column B and
calculate the total. Therefore, I have an overview of the
total expenses for each categorie, in one worksheet.

Thanks in advance for any help.

 

[Frank Kabel]

Hi,

if I understood you can try the following formula in B2:
=SUM(Table_January:Table_December!B2)

Frank

 

[Bob Phillips]

Assuming that the month sheets are called Jan, Feb, etc, and assuming that
all sheets are the same format, a summary formula could be


=SUM(Jan:Feb!B2)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[GT]

Hi,

Thanks for your help and sorry fornot being clear. I will
try again.


I have an expense tracking Excel file, with worksheets for
every months. Each worksheet has the same format.
Column A has a controlled list of expense type (Office
Supplies, Entertainment, Telehpone...etc). Column B has
the amount. Each row is an expense. Here is an example:

- Worksheet 1 (Jan 04)
COLUMN A COLUMN B
Telephone $245
Rent $500
Gaz $46
Office Exp. $456

- Worksheet 2 (Feb 04)
COLUMN A COLUMN B
Telephone $233
Rent $500
Gaz $12

etc....

I need to create a worksheet that resumes all the expenses
per category. That means that I need to write a formula
for each expense type that does the following, for
exmaple: Find in all the worksheets, in Column A a value
equal to "Telephone", get the value on the same row in
column B and calculate the total for this category only.

Therfore, on the first worksheet it will resume all my
expenses for year in each category.

I thank anyone in advance for his ingenious help !.

Regards.

 

[GT]

Hi,

Thanks for your help and sorry fornot being clear. I will
try again.


I have an expense tracking Excel file, with worksheets for
every months. Each worksheet has the same format.
Column A has a controlled list of expense type (Office
Supplies, Entertainment, Telehpone...etc). Column B has
the amount. Each row is an expense. Here is an example:

- Worksheet 1 (Jan 04)
COLUMN A COLUMN B
Telephone $245
Rent $500
Gaz $46
Office Exp. $456

- Worksheet 2 (Feb 04)
COLUMN A COLUMN B
Telephone $233
Rent $500
Gaz $12

etc....

I need to create a worksheet that resumes all the expenses
per category. That means that I need to write a formula
for each expense type that does the following, for
exmaple: Find in all the worksheets, in Column A a value
equal to "Telephone", get the value on the same row in
column B and calculate the total for this category only.

Therfore, on the first worksheet it will resume all my
expenses for year in each category.

I thank anyone in advance for his ingenious help !.

Regards.

 

[Guest]

IF ound the answer using the SUMIF function, to filter the SUM function base on the categories I created. Therefore I can create a function that says calcualte the SUM of B column IF cel in A column equals "Salary" (for example). Thanks for your help !