How reference entire column in formula (Spread DLL)

How reference entire column in formula (Spread DLL)

Posted by: bernard on 2 April 2018, 2:24 am EST

• 

  bernard

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 April 2018, 2:24 am EST

  I’m building a reporting engine with Spread DLL. One of the reports needs to apply a formula to cells in column E that count the number of cells in column C (entire column) that are less than or equal to the value of the cell in column D. For example:

  Col C Col D Col E
  
  2.3 7.4 3
  
  3.7 … …
  
  6.9
  
  12.6
  
  …

  When building the formula for E1, I don’t know the total number of rows. I need something like:

  COUNTIF( C, <=D#)

  The Spread docs don’t indicate any method for referencing an entire column. Is it possible?

• 

  bernard

  • Post Options:
  • Link
    Copy

  Posted 2 April 2018, 3:06 am EST

  Also, is it possible to include a cell’s row number in a formula like so:

  C# / ROW(#)

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 3 April 2018, 1:45 am EST

  Hi Bernard,

  You can include the range of cells in your formula like:

  COUNTIF(A1:A10 <=2) ’ for 10 rows

  I hope it answers your other question too(using row number in formula).

  Thanks,
  
  Deepak Sharma