Help with count problem

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

In analyzing a log file, I need to count the value in one column until the
value in another column is greater than or equal to a specified value. For
example count column AC that has the value of 36 until Column DD is >= to 6.
Any ideas?
 
In analyzing a log file, I need to count the value in one column until the
value in another column is greater than or equal to a specified value. For
example count column AC that has the value of 36 until Column DD is >= to 6.
Any ideas?
Click to expand...

Tom,

What is your end objective? Do you need the cell at which the counted
value in AC is greater than the same counted value in DD? Do you need
to know if the counted value in AC actually reaches a point in which
it is greater than the same counted value in DD? Please provide more
detail. In general, you can use the COUNTIF function to get the count
of a certain value.

Best,

Matthew Herbert
 
Matthew,

I am using the following formulas to count column AC:
=INT(COUNTIF(R[-2]C[-1]:R[4196]C[-1],36)/60) - to get hours and
=MOD(COUNTIF(R[-2]C[-2]:R[4196]C[-2],36),60) - to get minutes

the formulas woud reside in specified cells

The end objective is to compute the amount of time in column AC with a value
of 36 occurring until column DD is >= to 6 to determine when an alarm
occurred.
 
Back
Top