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

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

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

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