Im relatively new to excel so please excuse me if the answer is obvious. I have a sheet with several columns. On sheet 2 I have sumif reports on based on the criteria in a specific range. When that range (text) is sorted, I get an accurate result. But when I sort any other column so that the criteria range is not 'arranged' the sumif report changes. please help This is the sumif equation
=SUMIF('Price all products'!B12:B23875,"hnd",'Price all products'!BDE12:BDE23875)