Thread: Countif in VBA -- evaluate multiple criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott P Scott P is offline
external usenet poster
  
Posts: 26
Default Countif in VBA -- evaluate multiple criteria
I am trying to replicate a function such as this from Excel: {=COUNT(IF((B2:D120)*(B2:D12<=2),B2:D12))} in VBA. How do I evaluate multiple criteria using COUNTIF in VBA?
Reply With QuoteReply With Quote