my $statusCaseNumFormula = '=COUNTIF($I$3:$I$1000,$A$'; my $caseNumFormulaEnder = ')'; my $caseNumFormulaCounter = 4; my $formula = ''; my $row = 4; $caseNumFormulaCounter = $row + 1; $formula = $statusCaseNumFormula . $caseNumFormulaCounter . $caseNumFormulaEnder; $gray25percentFormat->set_align('right'); $worksheet->write_formula($row,$col, $formula, $gray25percentFormat);