COUNTA & COUNTIF Formula

[manoj_arsul]

Can you please help me to create the program below 2 formula .

=COUNTA((AD!A:A))

=COUNTIF(ADvsAV!I:I,"Present in AV")

 

[Joe4]

I am not sure I understand what your question is. Can you please elaborate?

 

[manoj_arsul]

i want to program in macro for below both the formulas . ie.

1. =COUNTA((AD!A:A))

2. =COUNTIF(ADvsAV!I:I,"Present in AV")

 

[JackDanIce]

Try:

Cells(1,1).Formula = "=COUNTA(AD!A:A)"
Cells(2,1).Formula = "=COUNTIF(ADvsAV!I:I,""Present in AV"")"

 

[manoj_arsul]

Jack thank u very much !!

 

[JackDanIce]

You're welcome