Remember, as well, that if your worksheet is large and complex, and the SUMIF formula is in a cell that is above your data table, it is possible that you may need two calculation passes to update the SUMIF function. Because when you calculate a worksheet, Excel basically calculates the cells from left to right and top to bottom.
If you have a very large worksheet, with lots of dependent calculations, and the calculations on which everything else is dependent are at the bottom or right side of the worksheet, then you may get incorrect results for the SUMIF function.
I tried a couple of things - "Formulas - Automatic" was checked, clicking "Calculate Now" and "Calculate Sheet" would not update the model.
The only way the to update the cell is to click on the formula and hit Enter or Tab.
For instance, you may think that the data you are changing in the worksheet is actually referenced in the SUMIF formula, but it may not be.
(If it isn't, then changing the data won't change the formula results.) Check the formula to make sure that it covers the proper range.
The problem I have is that the cells where the macro puts the summed values are in a chart that is supposed to create a bar graph.The cells have the formula =SUM(B3: B12) and so on, in them.Right now, every time that I run the macro I need to go into the cell with the formula, hit 'enter', and then it does the summation.Normally, if I change a value that a bar graph uses I see the bar graph change - but that does not happen with the cells that have values placed in them by the macro.I also have a section that sums the values in the chart to make sure it's running right, and these values do not update automatically as well.