View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Glen[_5_] Glen[_5_] is offline
external usenet poster
 
Posts: 31
Default How do I use countif an array for =45<=50

You could set up a variable just for keeping count.
Dim counter as integer
counter = 0
'put the If/Then statement in a loop to check the rows

If rowvalue =45 OR rowvalue <=50 then
counter = counter + 1
End If

HTH