Thread: [Solved] When I sort my data, the sumif report changes
View Single Post
 
Old 02-06-2014, 09:31 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default
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?
Reply With Quote