How to Combine Cells of Information in Excel

  • Thread starter Thread starter GT
  • Start date Start date
G

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.
 
Hi,

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

Frank
 
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)
 
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.
 
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.
 
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 !
 
Back
Top