SUMIFS + INDEX?

lost_in_the_sauce

Board Regular
Joined
Jan 18, 2021
Messages
62
Office Version
  1. 365
Platform
  1. Windows
I have a table of values, 150 rows of numbers with about 6 columns of names/identifiers/account names in A-F, and the rows are months/years 2015-current.

I'm trying to SUMIFS a specific column/columns on another tab based on the date (example, June 2022) which would be criteria in the SUMIFS but also 2 identifier criteria in the rows (columns C and F), I don't think I'm supposed to gram the entire data set - I just want to SUMIFS on a specific column, how do I index to just that one?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

mackc557

Board Regular
Joined
Nov 3, 2021
Messages
118
Office Version
  1. 2019
Platform
  1. Windows
Are you able to post either a screenshot or preferably a mini sheet from XL2BB? As they say, a picture is worth a thousand words (or more).
 

Forum statistics

Threads
1,175,803
Messages
5,899,562
Members
434,785
Latest member
Mymaccrack

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