Forum Discussion
Have sum calculation auto select largest/highest value
I have a time tracking spreadsheet that I have the following formula "=B10-($B$4-10)" in place. The bold section number value of the formula is manually changed to reflect the line of the largest va...
- This gives me the same value for all lines. Maybe in this direction.
- Your assistance is greatly appreciated.
If you enter the formula =B1-MAX(B:B)+10 in a cell, then fill down, the result should change from cell to cell, unless:
- Calculation Options is set to Manual, or
- You have circular references. The formula should not be in a cell in column B itself!
- Perfect, thank you so much. This will save me time used for manual formula correction. The formula is actually in column H on my spreadsheet, and I use it for two different reports I generate. Again, thank you HansVogelaar and m_tarler for your assistance.