SUMIFS + INDEX?

[lost_in_the_sauce]

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?

 

[mackc557]

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).

 

[lost_in_the_sauce]

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).

I'll try when I get home, no XL2BB at work