RE: $$Excel-Macros$$ Need a Suggestion for the formula

ny further assistance. ------- Ms.Exl.Learner --- On Fri, Aug 17, 2012 at 10:13 PM, Santosh Kumar Singh wrote: Dear Group, Please suggest How we can reduce this formula (if Possible) =COUNTIFS('Jan12'!F4:F60,"=Corrective",'J

$$Excel-Macros$$ help for Conditional Lock and unlock cells

Hay looking for help .. Column C D open for entry a Locked d Locked a Locked

$$Excel-Macros$$ Need a Suggestion for the formula

Dear Group, Please suggest How we can reduce this formula (if Possible) =COUNTIFS('Jan12'!F4:F60,"=Corrective",'Jan12'!H4:H60,"=DATA",'Jan12'!G4:G60 ,"=Completed")+COUNTIFS('Jan12'!F4:F60,"=Implementation",'Jan12'!H4:H60,"=DA TA",'Jan12'!G4:G60,"=Completed")+COUNTIFS('Jan12'!F4:F60,"=Traini