NEW QUESTION: How do I use SUMIFS with IMPORT RANGE in google sheets to sum a column based on referenced criteria (ex: "<="$K$5)?

UPDATED EDITS BELOW

I have a list of downloaded transactions that each correspond to a specific account code? I want to sum the amount (column G) based on the following criteria: segment (column A), account (column C), and transaction period, which is a number 1-12 (column F). Cell reference K1 is where the current period is located on the sheet.G3 references the segment.screenshot of data

The formula I have so far is:

=SUMIFS( 'Data'!G:G,
  'Data'!A:A, $G$3,
  'Data'!F:F, "<="$K$1,
  'Data'!C:C, A27
)

If I remove the criteria for column F, it gives me a total but it is incorrect and I cannot tell how it is summing the data. Of course I want to keep that criteria in but I'm not sure how to make it work.

Edit2 9/17/25 I now have the correct syntax for the right total using just SUMIFS referencing a sheet within the same workbook. How do I combine this syntax with IMPORT RANGE to reference a sheet in a different workbook?

Edit Below is the sample data as markdown table. Columns B, D, E omitted since they weren't in the original screencap.

The formula is using an incorrect syntax. Add a concatenation operator & in the second criterion:

=sumifs(
  'Data'!G:G,
  'Data'!A:A, $G$3,
  'Data'!F:F, "<=" & $K$1,
  'Data'!C:C, A27
)

See concat() a.k.a. &.