Thread: cointif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RobcPettit[_2_] RobcPettit[_2_] is offline
external usenet poster
 
Posts: 108
Default cointif

Hi im using T = Evaluate("COUNTIF(g15:g27," & """ & " < " & 6 &
"""")") to count how many values are smaller than 6. There are 9 such
values that are smaller, but this formula returns false. Any Ideas. Im
need to use this in vba. Ican get the correct answer in the worksheet
using the formula.
Regards Robert