COUNTA & COUNTIF Formula

manoj_arsul

Board Regular
Joined
Jun 27, 2018
Messages
61
Can you please help me to create the program below 2 formula .

=COUNTA((AD!A:A))

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

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,518
Office Version
  1. 365
Platform
  1. Windows
I am not sure I understand what your question is. Can you please elaborate?
 

manoj_arsul

Board Regular
Joined
Jun 27, 2018
Messages
61
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

Well-known Member
Joined
Feb 3, 2010
Messages
9,685
Office Version
  1. 365
Platform
  1. Windows
Try:
Code:
Cells(1,1).Formula = "=COUNTA(AD!A:A)"
Cells(2,1).Formula = "=COUNTIF(ADvsAV!I:I,""Present in AV"")"
 

Watch MrExcel Video

Forum statistics

Threads
1,109,533
Messages
5,529,397
Members
409,870
Latest member
Well59
Top