How could I sum visible negative cells in a single column. Could it be
possible with a combination of subtotal and sumif function. Here is my take
on this problem but it fails miserably
=IF(SUMIF(AL2:AL278,"<0",AL2:AL278),SUBTOTAL(109,A L2:AL278))

Please your help is needed.