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!

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)

"SharonP." wrote in message
...
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!