Quote:
Originally Posted by Debaser
Really? Works just fine for me. All the relevant figures are included in the SUMIF results. I get 7.8 for EstHours for 100001 even though one row in the source data is 100001 and the other is '100001
Are you saying it doesn't work for you?
|
Correct, it doesn't work for me on Office 365. In my pivot table the results for 100001 and '100001 produce two different rows. But the results from SUM look fine. (I wanted to learn to do this 2 different ways.) So it looks like a bug in the Pivot Table but not the SUM or SUMIF functions.