Excluding non zero values using the filter function

[bearcub]

I need to create a separate sheet for payroll by country based off of a payroll sheet. I am using the Filter function to this.
FILTER(FILTER('Comm_Sept 22 Intl Summary'!D4:N73,'Comm_Sept 22 Intl Summary'!D4:D73= A2),{0,1,1,0,0,0,0,0,0,1,1})

1) Is there a more efficient way to write this formula? In my criteria range, I only want the 2,3,9 & 10th columns.
2) How do I exclude reps who don't have commissions. Right now, it will pull everyone on the summary sheet that is based upon the country criteria
3) Is there a way to create a dynamic sum range based upon what is spilled from the list. The range will vary from month to month and I will like to create a total at the end of the list dynamically.

Here is an example of what I have presently based upon my formula. The Total was manually added, is there a way to make this dynamic based upon current employees being paid

Country	Name	Dept	Total Payment	Cur
GERMANY	Marc Ackermann (ZHGKQG5VN)	405000	7,500.00	EUR
GERMANY	Max Kleemann (6GXPEMSCY)	405000	7,500.00	EUR
GERMANY	Roy Schultheiss (LN8ZWI2KV)	405000	98,481.34	EUR
GERMANY	Sirko Schoeder (7KAXF29MO)	405000	7,500.00	EUR
GERMANY	Emel Rehberg (BPV7QDR90)	405000	0.00
GERMANY	Zoran Duvnjak (BORGUWVSV)	410000	2,550.45	EUR
GERMANY	Tatjana Wild (V02AD8W51)	430000	6,545.47	EUR
		Total	130,077.26

 

[bearcub]

I checked and no leading or trailing zeros. The issue that was confusing me was the VStack function and Choose. Given the original formula, it does look correct. Could it be that my input range is correct since I am starting with the rep name instead of the country name as I did. I'll reformat this file so it emulates the original file and see what happens. The file itself might be corrupted because I have no doubt the formula is correct.

 

[Fluff]

I suspect that the sum range is wrong, but that shouldn't return a #Calc error.

 

[bearcub]

I did try adjusting the sum range to a smaller range but I still had the same issue. I will adjust the file to the dimensions of the file that works and go from there. Thank you for all your help.