Export to EXCEL does not Count

[Poul]

When I have totals on a browse and include a count,
the Excel generated on an Export is something like  =COUNT(E4:E99)

But my column contains a mix of Numbers and AlphaNumerics.(Reference Numbers)
so is drastically not a count of all the rows.in the range.

The COUNT function counts the number of cells that contain numbers,
The COUNTA function counts the number of cells that are not empty in a range.
 
COUNTA would be a better choice, i think

poul
(nt8) Excel 2013

[Bruce]

Thanks for the info Poul, I'll update for that.

cheers
Bruce

[Bruce]

done in 9.07

[Poul]

Thanks Bruce,

Will that ever make it into NT8?

poul

[Bruce]

Hi Poul,

>> Will that ever make it into NT8?

Probably not. NT8 is currently in "maintenance" mode, and I'm avoiding any changes which may have knock-on effects.
This change may affect folk in ways I am not expecting, so I don't want to "fiddle" with NT8.

Cheers
Bruce