slight tweek needed

**khalid79m** · 04-04-2007, 04:52 AM

Please Login or Register  to view this content.

this code counts the number of "no call" in column 5 how can i get it to count "no call" and "no calls" in column 5.

**Bryan Hessey** · 04-04-2007, 05:02 AM

Originally Posted by khalid79m

Please Login or Register  to view this content.

this code counts the number of "no call" in column 5 how can i get it to count "no call" and "no calls" in column 5.

Hi,

try

Please Login or Register  to view this content.

note, I have avoided using "NO CALL*"

hth
---

**khalid79m** · 04-04-2007, 06:04 AM

Sorry it doesnt work

i need it to count both no call and no calls

and give a total

**Bryan Hessey** · 04-04-2007, 08:25 AM

Originally Posted by khalid79m

Sorry it doesnt work

i need it to count both no call and no calls

and give a total

Then try as Activecell.Formula = "=COUNTIF(CallData!E:E,""NO CALL"")+COUNTIF(CallData!E:E,""NO CALLS"")"

which works for me, I took it that your previous formula had worked.

---

**khalid79m** · 04-04-2007, 08:29 AM

how do i get a script to run if

in cell C2 it says "TL" or "Team Leader"

eg if C2 = "TL" or "Team Leader" then run "Macro1" if c2 = "IBC" then run "Macro2" , if C2 = "CSR" or "SMM" then run "Macro3"

and so on..