When I sort my data, the sumif report changes

amaka · #1 02-01-2014, 12:22 PM

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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Projects Cash Flow Report in Excel not creating monthly data	gardwr	Project	2	09-02-2013 09:10 AM
Cannot Convert Text Cell to number format to be able to sort the data	jyfuller	Excel	10	06-19-2013 05:31 PM
Button Filtering Data in a 2010 Report	runswick	Word	1	10-20-2012 11:03 AM
sort data in excel	cabot	Excel	1	08-17-2012 09:41 AM
Sort Data	rkeles	Excel	6	02-04-2012 01:31 PM