I've got a spreadsheat listing expenses in a column as well as payee, category, subcategory, and date. I'm summing the total expenses at the bottom of the expenses column through a certain range. When I sort all of these columns either with pull down menus or a VBA command button, the calculated value will change depending on how the table is sorted. Can anyone explain what is happening? Thank you.