countif

[tim]

I am having some problems...

What I am trying to do is to use countif like this...

countif(D$5:d5,">b5")

I am working on an incident tracker. The incident has a
beginning and an end. There can be multiple incidents
occurring at a given time. I am trying to determine the
number of incidents at the onset of a new incident. The
problem is the countif function will allow for b5, a
direct comparison or for example >10, a set comparison, I
need to be able to have b5 to change with each incident
here b is the start time and d is the end times


here is an example
incident beginning end number at one time
1175160 21:17:54 21:36:58 1
1175118 21:35:01 21:55:37 2
1175160 21:41:04 21:44:26 2
1175164 21:41:27 21:56:02 3

 

[Bob Phillips]

Tim,

Try

=COUNTIF(D$55,">"&B5)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tim]

does the trick, can you point me to where i would have
found that in, the help file in excel did not indicate i
could put the criteria like that

Thanks again,

Tim

 

[Bob Phillips]

Tim,

No idea I am afraid, just down to experience.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Tim

for some ideas (I don't think this is mentioned in the Excel help file)
have a look at:
http://j-walk.com/ss/excel/tips/tip52.htm
http://j-walk.com/ss/excel/tips/tip74.htm

Frank

 

[Harlan Grove]

does the trick, can you point me to where i would have
found that in, the help file in excel did not indicate i
could put the criteria like that ...

...

This is one of those things that wouldn't appear in online help because the
people who wrote online help would have considered it obvious how it would need
to be done. If your range in the first argument were text, how could you find
all text that would sort after the text string "b5" unless the criterion ">b5"
were interpreted as text?

 

[Guest]

Thanks for the help

-----Original Message-----
Tim,

No idea I am afraid, just down to experience.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.