possible COUNTIF?

[GD]

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?

 

[Max]

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]

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)

 

[francis]

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

 

[T. Valko]

Try this:

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

 

[JBeaucaire]

Give this a try:

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

Hi, i have a question. Columns A, B, C, D, E have data in the cell
ranging
between 1-90, indicating instances within a period of 90 minute
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 tha
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