Excel Sum function

Question

I want to analyse the sum of the cell range which is contained if functions and it changes automatically if the other cell is changed..for example

The value of h10 to h13 will be automatically changed when the value of d10 to d13 will be changed.and i want the sum value of d10:d13.but when i put the formula in the h14 cell=sum(h10:h13) the result is shown zero.

I know the sum function is applied on drop down list ...but in this case i can't solve the problem... Please help me

Answer 1

And also i am thankful to you...the problem is solved without any changing.. thank you very much.

Answer 2

And also i am thankful to you...the problem is solved without any changing.. thank you very much.

Answer 3

Thank you for your suggestions...but i can't change the data.d10 to d13 cell are contained drop down list...the moment i select applicable option from drop down list ..score will be in the cell h10 automatically change into 3...same in h11 will be 2...so on.i can manually select from drop down list... 3 2 1.but i want that the no will be automatically changed and the total no will be calculated from that numbers.

Answer 4

Hi,

My guess is that the values in those cells are text values that look like numbers and you really should correct that but this will sum those values.

=SUMPRODUCT(--(H10:H13))