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
The check boxes are defined to the cell I have them in (right now if I check the box it will say true, and if its not checked it says false.
Please help.
=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
The check boxes are defined to the cell I have them in (right now if I check the box it will say true, and if its not checked it says false.
Please help.
