SUMIFS with INDIRECT with multiple tabs & dynamic variables

Kam80

New Member
Joined
Apr 13, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi,
I have a file where i need to sum up the cost and accumulated depreciation of product codes that exists in different entities (the same product can exists in more than one entity) and the data are spread over 2 tabs:

The below is an example of my summary tab, as mentioned the product codes can exists in multiple entities and the cost amount and accum. depreciation balance needs to be summed together from the other 2 tabs (CAD & USD & others) and the formula needs to be dynamic since the user can select different year or months as desired.

1618292693101.png

In the other 2 tabs where the data is gathered, the date and year are in columns A & B and the unique identifier used for the sumif or sumifs is located in row 3.
I am not sure how to use INDIRECT and reference the other 2 tabs in the sumif formula.

Also I do not understand how INDIRECT can sum up the totals of the costs and accumulated deprec. over multiple columns?

1618292973277.png


Thank you
Kam
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,829
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Welcome to MrExcel Message Board.
Please Upload your example file & Desired result with XL2BB Add-in (Preferable) Or upload at Free hosting site e.g. www.dropbox.com or GoogleDrive or Onedrive and Insert Link Here.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,016
Messages
5,639,559
Members
417,099
Latest member
duhafnusa4

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
Top