I am building a workbook that tracks all transactions of a business. The sheet essentially has three tables in it. The first is for each individual transaction in all its details, the second conditionally sums the daily totals of each transaction type, and the third sums the month. All the formulas in the individual transaction record portion are functioning perfectly, however, in the daily totals the cells are not updating to display the values, or in one case updates to display the wrong value. Calculations are set to automatic. If you look at each cell with the formula builder the 'result' shows the correct value every time, and if you click on the formula bar at the top then hit enter the correct value will be generated. I have tried replacing all the '=' with new '=', I have tried re-saving to a new file, copying everything to a new file etc... I am now at the end of my rope and can not figure out what is wrong...

Any help would be greatly appreciated
Working in Excel Mac:2008