10th July 2006, 05:04 AM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Raven
i think that should be
=SUM($F$1:$F1)-SUM($E$1:$E1)
and drag that down the G column. should work
|
I think it's fine the way I wrote it. When aiming for simplicity over efficiency.
$E & $F expressions needlessly fix those columns. That can lead to problems if new columns are later inserted. |