I have a multi-variable data set I need to separate out into bins. I can't use Excel's histogram function as it won't meet my requirements. This is a problem I can easily solve using SUMIFS formulas, but I want to know if this can be done using a pivot table. But I don't know how to approach it that way.
I've attached a spreadsheet with a sample data set and the results I'm looking for using SUMIFS formulas. I'd appreciate any help in doing the same thing with a pivot table.
Thanks!
Quercus47
Perhaps the attached workbook contains an acceptable solution for you. I added a helper column with a lookup function to determine which bin each row falls in. Note that I had to transform the factor column to numbers as the lookup function wouldn't work otherwise.
Thank you. That should work. I hadn't considered the lookup column and was figuring this solution would require some complicated calculated fields or something. Your solution is much simpler.
Thanks,
Quercus.
