need help!



Is there a formula that will let me do the following;

Create a check box that allows me to select or deselect cells from and average formula.

Example,

If cell A1 is checked the value in b1 will be added to the formula =average()

Thank you in advance

Sure is.

Say the numbers are in column A and you put an "x" next to the ones you want summed in column B, then the formula you need is:

Modify the ranges as suits your needs.