NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Poul on March 11, 2016, 12:06:48 PM

Title: Export to EXCEL does not Count
Post by: Poul on March 11, 2016, 12:06:48 PM

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

Title: Re: Export to EXCEL does not Count
Post by: Bruce on March 13, 2016, 10:18:00 PM

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

cheers
Bruce

Title: Re: Export to EXCEL does not Count
Post by: Bruce on March 15, 2016, 04:17:28 AM

done in 9.07

Title: Re: Export to EXCEL does not Count
Post by: Poul on March 24, 2016, 11:15:14 AM

Thanks Bruce,

Will that ever make it into NT8?

poul

Title: Re: Export to EXCEL does not Count
Post by: Bruce on March 29, 2016, 11:31:16 PM

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