Consolidate Muliple tabs

N

Noid

Hi, first time poster.

What I am trying to do is roll up 4 tabs in a workbook to one tab
consolidated. The problem is that I have to roll them up in a chart of
accounts format. So, for example if the account number starts with 61
it is office supplies, 73 leased equipment, ect. What I can't figure
out is how to have all of the acct #'s that fall into a given criteria
to add up the actual's in another column that match the account #
criteria.

Thx
 
B

Bryan Hessey

Hi,

One easy way might be to put your criteria in a separate column before
the account number column, and keep a hidden running total in a helper
column based on that criteria.

--
 
N

Noid

I guess to make it easier I am trying to say that IF column A meets a
certain criteria, then add the cell beside it in column C. I think
this way I could back door into what I am trying to do.
 
B

Bryan Hessey

depending which way you want that read, to adjust column C, in C1 put

=if(A1=certain criteria,B1+WhatEverIn_C,WhatEverIn_C)

to adjust column D with column C if criteria is met, then, in column D
put

=if(A1=certain criteria,C+WhateverIn_D,WhatEverIn_D)

the 'whatever' refers to what you currently have to calculate column D

Does this help?

--
 
Top