Auto-sum with data validation

Question

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 column, the user can select multiple numbers. I want to auto-sum the numbers the user selects in the Hours/UM column. &nbsp;

logaraj sekar · Answer

Hi&nbsp;Brooke Eisenhauer,&nbsp;In which column you want to AUTOSUM.

brooke eisenhauer · Answer

I want to auto-sum the hours/UM column.

logaraj sekar · Answer

Hi&nbsp;Brooke Eisenhauer,&nbsp;If number of records is fixed (i.e. if only two rows). You put =SUM(CELL1,CELL2) as formula.&nbsp;If number of records varies, I will suggest macro.

Forum Discussion

Auto-sum with data validation

3 Replies

Resources