I need to check if any of the values in the range of A69 to A90 are less than 2. If they are less than 2, I want to total them and return the value to H88.
I then wish to create a graph over the range A69 to A90 exclusing all values of less than 2. I'm not sure at this stage whether it is easier to do the whole process using code or by inserting the formula into a template. Any suggestions will be greatly appreciated.
thanks
Matt
I then wish to create a graph over the range A69 to A90 exclusing all values of less than 2. I'm not sure at this stage whether it is easier to do the whole process using code or by inserting the formula into a template. Any suggestions will be greatly appreciated.
thanks
Matt