Consolidate and Merge Data on a Separate Sheet

[astole]

Trying to consolidate and Merge Data on a Separate Sheet

[rlh06]

I believe the attached will accomplish what you need done.

*Edit: there seems to be a server crashing issue preventing the attachment actually attaching. The following formula should work for the balance column in sheet 2. You should be able to drag that over and down to capture the other totals you are looking to consolidate from the other tab.

=SUMIF(Information!$A:$A,Sheet2!$C15,Information!B:B)

[rlh06]

I believe the attached will accomplish what you need done.

*Edit: there seems to be a server crashing issue preventing the attachment actually attaching. The following formula should work for the balance column in sheet 2. You should be able to drag that over and down to capture the other totals you are looking to consolidate from the other tab.

=SUMIF(Information!$A:$A,Sheet2!$C15,Information!B:B)

[rlh06]

My apologies for the double post. Seems to be a real traffic issue on the forum today. Essentially though, a sumif consists of: a range containing criteria(column A of your Information tab where all the lender codes are), a specific value within your criteria range (cell containing each lender code), and the range you actually want summed (column B for the original balance, column C for balanced owed, etc).

[astole]

I tried that, but it's not summing numbers. Here's an example, Row 1 has Lender, Amount, APR, and Payment. There are 4 rows for mortgages, then 4 for Auto Loans, 4 for Personal, etc. Say there is one of each debt listed, leaving 3 rows per debt blank. I am trying to have all that information auto populate on another sheet in order without having any blank rows between in each other.