SUMIFS between two number values

[geckoman]

I am trying to sum a number of values (areas) in one column and using a second set of values (elevations) to limit the sum range. I am referencing a different spreadsheet, but trying to use criteria (values) in the present spreadsheet (I don't think this is what is causing the issue though).

If I set up the formula putting in the actual values for the criteria, then I get a result:

=SUMIFS('[Ore Type bench V.3_ jev.xlsx]Comb LA-Groups (2)'!E$4:E$443,'[Ore Type bench V.3_ jev.xlsx]Comb LA-Groups (2)'!$B$4:$B$443,">=3060",'[Ore Type bench V.3_ jev.xlsx]Comb LA-Groups (2)'!$B$4:$B$443,"<3198")

But if I try to reference the cells where the values are, I get an error message:
=SUMIFS('[Ore Type bench V.3_ jev.xlsx]Comb LA-Groups (2)'!E$4:E$443,'[Ore Type bench V.3_ jev.xlsx]Comb LA-Groups (2)'!$B$4:$B$443,">=AG3",'[Ore Type bench V.3_ jev.xlsx]Comb LA-Groups (2)'!$B$4:$B$443,"<AH3")

I've tried all permutations with quote marks, etc., to get this to work as I have used a vlookup to pull the correct values into cells AG3 and AH3 (etc.). What am I missing?

TIA
John V

 

[Phuoc]

Try change: ">=AG3" , "<AH3"

to: ">="&AG3 , "<"&AH3

 

[geckoman]

Try change: ">=AG3" , "<AH3"

to: ">="&AG3 , "<"&AH3

Thank you! I had the quote marks around it all like ">=&AG3" Missed that permutation!