possible COUNTIF?
 

Hi, i have a question. Columns A, B, C, D, E have data in the cells ranging
between 1-90, indicating instances within a period of 90 minutes something
happened, so E.G 47, 85, 53 etc..

In column G I have the same kind of data, 1-90.

In Column H I want to put in a formula which counts how many of the
instances in columns A,B,C,D,E are of less numerical value than that in
column G on the same row.

So for Example...

A B C D E F G H
22 45 62 84 89 56 2

Struggling a bit with it, any ideas?

possible COUNTIF?
 

Yes, why not COUNTIF?

Assuming data in row2 down
In H2, copied down: =COUNTIF(A2:E2,"<"&G2)

Works? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"GD" wrote:
Hi, i have a question. Columns A, B, C, D, E have data in the cells ranging
between 1-90, indicating instances within a period of 90 minutes something
happened, so E.G 47, 85, 53 etc..

In column G I have the same kind of data, 1-90.

In Column H I want to put in a formula which counts how many of the
instances in columns A,B,C,D,E are of less numerical value than that in
column G on the same row.

So for Example...

A B C D E F G H
22 45 62 84 89 56 2

Struggling a bit with it, any ideas?

possible COUNTIF?
 

Hey, thanks for this, it works in as much as it adds the totals of the
figures up, however I was looking for more how many times the instance
occures, so rather than adding 45, 67, 89 up to report 201, it would report 3
(if the cell in G2 was 90)

"Max" wrote:

Yes, why not COUNTIF?

Assuming data in row2 down
In H2, copied down: =COUNTIF(A2:E2,"<"&G2)

Works? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"GD" wrote:
Hi, i have a question. Columns A, B, C, D, E have data in the cells ranging
between 1-90, indicating instances within a period of 90 minutes something
happened, so E.G 47, 85, 53 etc..

In column G I have the same kind of data, 1-90.

In Column H I want to put in a formula which counts how many of the
instances in columns A,B,C,D,E are of less numerical value than that in
column G on the same row.

So for Example...

A B C D E F G H
22 45 62 84 89 56 2

Struggling a bit with it, any ideas?

possible COUNTIF?
 

Hi GD

Max's formula works, its return 2 in H2 to the example provided
A B C D E F G
22 45 62 84 89 56

=COUNTIF(A2:E2,"<"&G2)

Copy and paste the formula into cell H2

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis





"GD" wrote:

Hey, thanks for this, it works in as much as it adds the totals of the
figures up, however I was looking for more how many times the instance
occures, so rather than adding 45, 67, 89 up to report 201, it would report 3
(if the cell in G2 was 90)

"Max" wrote:

Yes, why not COUNTIF?

Assuming data in row2 down
In H2, copied down: =COUNTIF(A2:E2,"<"&G2)

Works? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"GD" wrote:
Hi, i have a question. Columns A, B, C, D, E have data in the cells ranging
between 1-90, indicating instances within a period of 90 minutes something
happened, so E.G 47, 85, 53 etc..

In column G I have the same kind of data, 1-90.

In Column H I want to put in a formula which counts how many of the
instances in columns A,B,C,D,E are of less numerical value than that in
column G on the same row.

So for Example...

A B C D E F G H
22 45 62 84 89 56 2

Struggling a bit with it, any ideas?

possible COUNTIF?
 

Try this:

=COUNTIF(A1:E1,"<"&G1)

--
Biff
Microsoft Excel MVP


"GD" wrote in message
...
Hi, i have a question. Columns A, B, C, D, E have data in the cells
ranging
between 1-90, indicating instances within a period of 90 minutes something
happened, so E.G 47, 85, 53 etc..

In column G I have the same kind of data, 1-90.

In Column H I want to put in a formula which counts how many of the
instances in columns A,B,C,D,E are of less numerical value than that in
column G on the same row.

So for Example...

A B C D E F G H
22 45 62 84 89 56 2

Struggling a bit with it, any ideas?

possible COUNTIF?
 

Give this a try:

=COUNTIF(A1:E1,"<"&G1)

GD;247559 Wrote:
Hi, i have a question. Columns A, B, C, D, E have data in the cells
ranging
between 1-90, indicating instances within a period of 90 minutes
something
happened, so E.G 47, 85, 53 etc..

In column G I have the same kind of data, 1-90.

In Column H I want to put in a formula which counts how many of the
instances in columns A,B,C,D,E are of less numerical value than that
in
column G on the same row.

So for Example...

A B C D E F G H
22 45 62 84 89 56 2

Struggling a bit with it, any ideas?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=69058