Summing a Column instead of a Column range

S

SharonP.

Asking the experts here - this calc seems to work but is there a problem with
summing this way? It would make it easier than always knowing the last row
on the sheet and shorten my formulas some.

=SUMIF(AdjData!M:M,"BC",Annualize_P!M:M)
=SUMIF(AdjData!$M$2:$M$701,"BC",Annualize_P!$M$2:$M:$701)

Thanks!
 
B

Bob Phillips

No there is no problem. Testing I did suggests that it is more efficient to
use the column like that than a dynamic named range, Excel seems to know
where to stop.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top