axlsx array formula attempt

gistfile1.rb

require 'axlsx'

p = Axlsx::Package.new
wb = p.workbook

def rcf(likelihood, impact)
        return "=COUNT("\
                    "IF("\
                        "(LEFT(TRIM(CLEAN(Data.A2:Data.A26))) = \"#{likelihood}\")"\
                        "*"\
                        "(LEFT(TRIM(CLEAN(Data.B2:Data.B26))) = \"#{impact}\")))"
end


wb.add_worksheet(:name => "Data") do |sheet|
    sheet.add_row ["A", "B"]
    for i in 1..5 do
        for j in 1..5 do
            sheet.add_row [i.to_s() + " - foo", j.to_s() + " - bar"]
        end
    end
end

wb.add_worksheet(:name => "Summary") do |sheet|
    sheet.add_row ["Foo", "Bar"]
    sheet.add_row [rcf(1,5), rcf(2,5)]
end

p.serialize 'test.xlsx'