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

Countif Problem
 

You just need to separate each as an individual function like this:

=COUNTIF(H2:H11,"Scheduled")+COUNTIF(H76:H83,"Sche duled")+COUNTIF(H49:H50,"Scheduled")

Better to use a cell to hold the criteria:

A1 = Scheduled

=COUNTIF(H2:H11,A1)+COUNTIF(H76:H83,A1)+COUNTIF(H4 9:H50,A1)

--
Biff
Microsoft Excel MVP


"Lise" wrote in message
...
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

Countif Problem
 

hi
try using the address of the first instance of the word sheduled instead of
the word itself and use this format for the formula
=COUNTIF(H2:H11,H4)+COUNTIF(H76:H83,H4)+COUNTIF(H4 9:H50,H4)


regards
FSt1

"Lise" wrote:

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

Countif Problem
 

Thanks to you both - frustration level back to normal :-)
--
Thanks

Lise


"FSt1" wrote:

hi
try using the address of the first instance of the word sheduled instead of
the word itself and use this format for the formula
=COUNTIF(H2:H11,H4)+COUNTIF(H76:H83,H4)+COUNTIF(H4 9:H50,H4)


regards
FSt1

"Lise" wrote:

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