Posted to microsoft.public.excel.misc

external usenet poster

Posts: 102

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif problem	Martin	Excel Discussion (Misc queries)	1	March 3rd 08 10:01 AM
COUNTIF problem	Phil C	Excel Discussion (Misc queries)	4	May 29th 07 04:28 PM
COUNTIF problem with NOW()	Spreadsheet	Excel Worksheet Functions	21	June 26th 06 09:47 PM
countif problem.	psion	New Users to Excel	2	October 6th 05 01:21 AM
countif problem	SLKPM	Excel Worksheet Functions	2	September 29th 05 08:08 PM

All times are GMT +1. The time now is 03:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us