Sum multiple sheets matching multiple criteria

tholland3433

New Member
Joined
Jul 20, 2021
Messages
6
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Hello All,
I am hoping someone can help. I have a worksheet with several tabs. I am needing to do a summary on the audit summary sheet that adds up balances based on the year and category.
The tabs I am needing to sum I have named Lookup sheets on my summary tab (not sure if that is needed). The tabs that contain the detail are the month tabs (july, august, septemeber, etc). The totals will need to correspond to the year in both the month and the summary tab. Additions column on the summary I need to add up the criteria from the month sheets that are under the columns of principal real and personal scroll and discoveries for each corresponding year. For the collections total it will be the Principle Real and Personal Payment and Releases & Adjustment.
Help is greatly appreciated.

I am not able to get the XL2BB to work it just keeps spinning and never copies. Hopefully you are able to help via screen shots.

Summary Sheet Starts with column A year starts in Row 12
1629211640914.png


One of the month sheets

1629211672631.png
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top