Forum Discussion
Solved
Return a value in formula so SUMIFS can subtotal
I have a formula I have a Pivot Table I use to sum data of costs and wish to use those values to forecast months without actuals. Column H is a helper column that helps to identify whether the values...
Jpalaci1 Your formula creates circular references. To avoid that , change it so that is sums from the first row of the pivot table to the row direct above the cell where the formula is entered. Don't enter the formula in the very first row. See attached. Now you can start typing the forecast amounts and the sub-totals should calculate correctly.
Jpalaci1 Your formula creates circular references. To avoid that , change it so that is sums from the first row of the pivot table to the row direct above the cell where the formula is entered. Don't enter the formula in the very first row. See attached. Now you can start typing the forecast amounts and the sub-totals should calculate correctly.
- Thank you so much! This worked very well.
