[AccessD] Exporting Access to Excel - How to "SUM" a column with a variable number of rows?

Brad,

When you mention data that should not be summed are you talking about a
mixture of text and numbers? Dates ? What?

Do you plan to test on sheet?

EXCEL
=CountA(range ) = Count(range) is one test for mixture of text and numeric
in bulk.

Can also be tested with Evaluate ... as in if xl.EVALUATE ("=counta(" &
Rng.address & ") = Count (" & rng.address & ")") = True then...
On Jul 26, 2011 4:43 PM, "Brad Marks" <BradM at blackforestltd.com> wrote: