Printable View
Hi,
Can any one tell me that how to use Countif function in VBA (Macro Programming). I need to count the no.of rows with specifying the criteria. I can do this using for loop and but just want to know whether is it possible to use simple function rather than using loop and conditional statements.
Thanks in Advance !
Warm regards,
Di$cover
There might be other ways - I'm not entirely sure what you want to do - but you can use Application.CountIf(Range("a1:a20"),"=5") for example
Moved to Excel Help forum...
Thanks for the reply Tony.. but when i put this formula it is returning "0" value. my code is goes like this...
Sheets("Daily Call Report").Range("C8").Select
ActiveCell.FormulaR1C1 = Application.CountIf(Range("H1:H400"), "=17/05/2006")
i want to count how many rows r there in a sheet which contains the date "17/05/2006".
Thanks in Advance !
You're better off using CountA for that...
[vba]Option Explicit
'
Sub Try()
With Sheets("Daily Call Report")
.Range("C8") = Application.CountA(Range("H1:H400"), "=17/05/2006") - 1
End With
End Sub[/VBA]
probably a silly question but why do you want to use VBA to put the formula result in the cell rather than putting the formula itself in the cell?
Yes it is a silly question.. i know.. but the code what i sent is a just part of it. and more over this report is very big one.. and it includes only the count of no.s. so i thouhgt of creating a macro. Any way ... thanks for your help. i wil get back to you.. once i use this code in my program.