Forum Discussion
Auto-sum with data validation
I want to auto-sum numbers that are determined through indirect data validation. I created the difficulty column with data validation that determines the drop-down list in Hours/UM. In the Hours/UM c...
I want to auto-sum the hours/UM column.
If number of records is fixed (i.e. if only two rows). You put =SUM(CELL1,CELL2) as formula.
If number of records varies, I will suggest macro.
