countif

T

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
 
B

Bob Phillips

Tim,

Try

=COUNTIF(D$5:D5,">"&B5)

--

HTH

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

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
 
B

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)
 
H

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?
 
G

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)




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top