Thread: Countif and
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HH[_4_] HH[_4_] is offline
external usenet poster
 
Posts: 42
Default Countif and

I can't seem to come up with the right code to say the following:

Count if $H&1:$H199 = "5th" and if B2 = "Active"

H1:199 will always be the same reference. B2 will change to c3, etc.

Help please
Hank