When I sort my data, the sumif report changes

		Microsoft Office Forums > Microsoft Excel > Excel
When I sort my data, the sumif report changes

02-06-2014, 09:31 PM

BobBridges BobBridges is offline

Windows 7 64bit When I sort my data, the sumif report changes

Office 2010 32bit

Expert

Join Date: May 2013

Location: USA

Posts: 700

I dunno, amaka, maybe you accidentally uploaded the wrong workbook. The one I'm looking at doesn't have any data past row 51:

Code:

=SUMIF('Price all products'!B12:B51,"hnd",'Price all products'!#REF!)

And the last range in the function has the #REF error. If this is the right workbook, maybe you deleted a bunch of rows to make the example simpler?

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:59 AM.