Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif only once | Excel Discussion (Misc queries) | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |