Hi There,

I am trying to write a macro that get the total (Sum of Column B) of a column if row is infinite (meaning number of rows varied up to 5000 rows). Please see example data below.

A B
Invoice Summary Report
Account Total Amount Due
9 $24.94
22 $346.40
27 $153.34
42 $202.58
48 $31.24
53 $120.97
3671060 $3,484.06

Any help is very much appreciated. Thanks
Andrew