Code do not recognize retrieved value

Hi there, will appreciate any help on this thread. I have this code created by djbomaha that in Y7 count cells that contain values over 0.01 from the X9:X48 cell range and also from the same range of cells X9:X48 count cells that contains values from 8.5 but not higher than 10 IN Q49, count cells that contains values from 6.5 but not higher than 8.4 IN Q51, count cells that contains values from 4 but not higher than 6.4 IN Q53, count cells that contains values higher than 0 but not higher than 3.9 IN Q55, this counts are kept when i clear contents in the range of cell X9:X48 and them adds up the new counts to previews counts, the code it does eaxactly what i need, the problem is that works only when i type and enter the values on the range of cells X9:X48, when the values on the cells range X9:X48 are retrieved with formula from the range of cells L17:L26, T17:T26, L33:42 and T33:T42 the code does not recognize the retrieved values into X9:X48 and does not do the cumulative count on Y7, Q49, Q51, Q53, Q55. What i need is that when i enter values on cell ranges L17:L26, T17:T26, L33:42 and T33:T42 those values to be recognized by the code in Y7, Q49, Q51, Q53, Q55 I have attached The file for better reference. Many thanks for any help

Please Login or Register  to view this content.

The problem is that the code isn't triggered when a value changes as the result of a formula.

The following code monitors the cells you'll, I assume anyway, be entering data.

Please Login or Register  to view this content.

Norie, thanks you very much, the code is not getting trigged, actually my data entry is on cell range G17:K26, O17:S26, G33:K42, O33:S42 it does work perfect, if i type and enter the values on the cels range L17:L26, T17:T26, L33:L42, T33:T42 but the values on this range of cells L17:L26, T17:T26, L33:L42, T33:T42 are retrieved from formula that refers to the data entry values on the range of cells G17:K26, O17:S26, G33:K42, O33:S42, see attached file for better reference, sorry about this and many thanks if you could helpme to correct this.