|
|
#5
03-18-2014, 09:45 AM
|
|||
|
|||
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. 
|
|
|
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 |
Windows 8 
Office 2010 64bit
Threaded Mode