Help make formula not execute unless a checkbox is checked

[Strongo]

Is there anyway to make a formula not take effect or execute unless a check box (one checkbox for each customer going down the same column)has been checked. I have no idea how to do macro. Here is the formulas I want to not allow to execute unless the checkbox is checked.

=COUNTIFS(Sales,">=499",Rollover!$O$10:$O$1318,[@[IC''s]])-COUNTIFS(Sales,">=2500",Rollover!$O$10:$O$1318,[@[IC''s]])

and

=COUNTIFS(Sales,">=2500",Rollover!$O$10:$O$1318,[@[IC''s]])-COUNTIFS(Sales,">=10000",Rollover!$O$10:$O$1318,[@[IC''s]])

and

=COUNTIFS(Sales,">=10000",Rollover!$O$10:$O$1318,[@[IC''s]])

The check boxes are found in

'MASTER INPUT SHEET'!O2:O283

 

[Crystalyzer]

Do your checkboxes have the cell link defined? If so, then assuming the cell links are the cells that the checkboxes are in, this is simple to achieve. Basically you will use the cell link for each checkbox to determine if the formula should be calculated or if a blank will be displayed by using an IF statement as follows:

IF('MASTER INPUT SHEET'!O2,COUNTIFS(Sales,">=499",Rollover!$O$10:$O$1318,[@[IC''s]])-COUNTIFS(Sales,">=2500",Rollover!$O$10:$O$1318,[@[IC''s]]),"")

AND

IF('MASTER INPUT SHEET'!O2,COUNTIFS(Sales,">=10000",Rollover!$O$10:$O$1318,[@[IC''s]]))

 

[Strongo]

I dont know how to define a checkbox. Can you help me with that?

 

[Crystalyzer]

If you right click on each checkbox, you can see the properties and define the cell that will contain the value of the checkbox (i.e. True or False)

 

[Strongo]

K,

I went into each checkbox and defined to the cell they are currently sitting in and now all the cells

Then i went in and copied and pasted the formulas you told me:

IF('MASTER INPUT SHEET'!O2,COUNTIFS(Sales,">=499",Rollover!$O$10:$O$1318,[@[IC''s]])-COUNTIFS(Sales,">=2500",Rollover!$O$10:$O$1318,[@[IC''s]]),"")

AND

IF('MASTER INPUT SHEET'!O2,COUNTIFS(Sales,">=10000",Rollover!$O$10:$O$1318,[@[IC''s]]))

When I put those in and push enter they dont do anything. In fact the formula then shows up in the cell and it doesnt calculate anything. What am I doing wrong?

 

[Crystalyzer]

You probably have the quotes preceding your equals sign OR you don't have the equals sign

 

[Strongo]

Sorry,
The first line in my last response was suppose to say... and now all of the cells say true if I have the box checked and false if the box is not checked

 

[Strongo]

I put the = sign in and nothing after I copied and pasted your formula... Im sorry I dont know how else to explain what I need.