PDA

View Full Version : countifs in the VBA



shahabsoltan
07-27-2014, 11:11 AM
Hi
how Using the function "countifs" in VBA ?

Bob Phillips
07-27-2014, 02:16 PM
You need to be a bit more specific than that.

shahabsoltan
07-28-2014, 11:27 AM
I found myself


TextBox5.Text = WorksheetFunction.CountIfs(Sheet1.Range("b:b"), TextBox2.Text, Sheet1.Range("f:f"), (">=" & TextBox3.Text), Sheet1.Range("f:f"), ("<=" & TextBox6.Text))

Aussiebear
07-30-2014, 08:41 PM
Are you able to post a sample workbook showing what it is that you are trying to do? I am unable to follow what you are trying to explain at this point.