Forum Discussion
Summing a row of drop down lists VALUE error
Hello all, I am trying to sum a row of cells where each cell has a drop down list created through Data Validation using Excel 2010. Each list has 2 options, a blank cell or a time that is formatted...
Alex,
Why use =TEXT to add the times as all your values are in time format anyway so a simply adding the cells will give the same answer.
check https://support.office.com/en-us/article/how-to-correct-a-value-error-in-average-or-sum-functions-3efd0acb-b9fb-4152-aaa7-7777ea9b3d51 for correcting value errors
Why use =TEXT to add the times as all your values are in time format anyway so a simply adding the cells will give the same answer.
check https://support.office.com/en-us/article/how-to-correct-a-value-error-in-average-or-sum-functions-3efd0acb-b9fb-4152-aaa7-7777ea9b3d51 for correcting value errors