my $first = 'C2';
my $second = 'C9';

for my $r (3..4)
{

    $worksheet->write("E$r", "=COUNTIF($first:$second, \"pass\")"); 
    $r++;
    $worksheet->write("E$r", "=COUNTIF($first:$second, \"FAIL\")");         
}