Thread: [Solved] When I sort my data, the sumif report changes
View Single Post
 
Old 03-18-2014, 09:45 AM
amaka amaka is offline Windows 8 Office 2010 64bit
Novice
  
Join Date: Feb 2014
Posts: 4
amaka is on a distinguished road
Default Still getting the wrong sumif report if I sort my data. SOS
Hello

This problem is literally driving me nuts. Please see the attached excel sheet. When The raw data sheet of all product is sorted by product I get a sunif in Jul on the premium sheet of 85200 which is wrong. When the price sheet is sorted by Product, I get a sumif value of 107800, the correct one.

How can I keep the sumif function correct regardless of the sorting in the original sheet.
Attached Files
File Type: xlsx excel question.xlsx (112.0 KB, 12 views)
Reply With Quote