I need to insert COUNT.IF or SUM(IF... array formula: any suggestion?
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
rbenit68 · 2016-01-27 12:03

Hi,

I am  trying to provide calculated cells to a CSV file, and exporting
to XLS. I need to insert COUNT.IF.

I have considered rev3279 but also I need InsertRow and InsertCol
functions implemented in rev3381 where COUNTIF is still present. Are
there a reliable revision where both features are present?

If the above is not possible I could mimic the COUNT.IF using
SUM(IF... array formula construction, but I think is not implemented
yet.

Any further suggestion?

TIA
Miguel Ruiz
12-18 yr physics teacher.
Sevilla, Spain.

----------------------------------------------------------------------
wp · 2016-01-27 18:44

Added COUNTIF, SUMIF, and AVERAGEIF functions to trunk (I had removed
them after I had reconstructed the formula engine because checking the
IF condition is quite a mess). Not heavily tested yet, but basically
it should work. Note that AVERAGEIF cannot be written to xls files.
Note also that array formulas are not yet implemented in
fpspreadsheet.

----------------------------------------------------------------------
rbenit68 · 2016-01-27 19:10

Woow!!! Thank you so much.

I will keep you informed about any difficulty or success I encounter.

Miguel.