ARRAY formula

[orsm6]

Hi all, on a spreadsheet I would like to list the top ten values of a list of items using the LARGE function and sets of criteria, I entered this formula in and it works, but when I try to expand it by adding another 3 or more criteria it doesn't work, any suggestions please on how I can add extra criteria to make it work??

{=IFERROR(LARGE(IF(('sap dump 2'!C:C>="PA000000")*('sap dump 2'!C:C<"PA100000"),'sap dump 2'!G:G),ROW(A1)),"")}

I want to add more criteria that may look like this: ('sap dump 2'!C:C>="20000000")*('sap dump 2'!C:C<"30000000"),

thanks in advance

EDIT: When I say it works I mean that it will list the top ten with that criteria, but because I cant expand the criteria I am missing data

 

[orsm6]

how come the sumifs works? it still has to evaluate the cell I thought it'd be the same as an IF except adding values together