Thread: Countif Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lise Lise is offline
external usenet poster
 
Posts: 102
Default Countif Problem

Hi Everyone - I am trying to count the number of times Scheduled appears in
various cells so have used formula
=COUNTIF(H2:H11,"Scheduled"+COUNTIF(H76:H83,"Sched uled"+COUNTIF(H49:H50,"Scheduled")))

But this not working and brings back 0 when it should be 4 - should I be
using a different formula?

Many Thanks

Lise