Example Please?

L

Lee Hunter

Would someone please show me an example of using countif
as a workbook function.

I have used the FInd function to determine the starting
row, Set c = .FInd("1st wave", LookIn:=xlValues)
If Not c Is Nothing Then
d = c.Row
End if
I want to count the number of rows,in column B that
contain the number 1 from the row returned from the Find
for the next 25 rows.

I sincerely appreciate your assistance,
 
S

Steve Schapel

Lee,

The focus of this newsgroup is programming Forms in Micosoft Access. It
would appear your question relates to Excel rather than Access, and as
such you might have a better chance of a good response in an Excel
newsgroup, for example microsoft.public.excel.programming.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Macro 9
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
lookup and return column number 2
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Run-Time Error "9". Subscript out of range 3
Vlookup or similar 7
create new worksheet"ERROR" 0

Top