SUMIFS using multiple criteria from same table column

[mattjpep]

I have the following formula:

SUM(SUMIFS(SD[Gross Amt],SD[FY],[@FY],SD[Period],AY$1,SD[Employee ID],[@[Emp ID]],SD[Title Code],{[@[Ttl Chg]],[@[Title Code]]}))

The part in bold is what I need help with. Typically, you would use the braces for multiple criteria in the same column, however I'm not sure how to adapt this for criteria from a table. Is this even possible? I appreciate any help. Thanks.

 

[Anand Sharma]

Hi

Below is structure of Sumifs

SUMIFS(Range you want to sum, range having criteria , your criteria, criteriaRange2, criteria2, .....continue)

 

[FDibbins]

The problem with structured tables (for me, at least) is how formulas get structured - sometimes to the point of making reading them really hard. What exactly is that formula doing?

 

[mattjpep]

This is pulling data from a table:

=SUM(SUMIFS(SD[Gross Amt],SD[FY],[@FY],SD[Period],AY$1,SD[Employee ID],[@[Emp ID]],SD[Title Code],{[@[Ttl Chg]],[@[Title Code]]}))

The red is the data I'm totaling
The blue is looking for the year in the table and referencing the year on my other tab for a match.
The orange is looking for the period and referencing the period on my other tab for a match.
The pink is looking for the employee ID and then referencing the Emp ID column in my table for a match.
The green is looking for the title code and then referencing the title code is two different columns for a match.

This is a formula I use all the time, with one exception. I usually have specific data (i.e. {"Title1","Title2"}) where the bold currently is. In this formula, I'm using table column names and it's giving me an error. Is there another way to use the table column names?