View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default 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?