NetTalk Central

Author Topic: Export to EXCEL does not Count  (Read 4057 times)

Poul

  • Full Member
  • ***
  • Posts: 160
    • View Profile
Export to EXCEL does not Count
« 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

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Export to EXCEL does not Count
« Reply #1 on: March 13, 2016, 10:18:00 PM »
Thanks for the info Poul, I'll update for that.

cheers
Bruce

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Export to EXCEL does not Count
« Reply #2 on: March 15, 2016, 04:17:28 AM »
done in 9.07

Poul

  • Full Member
  • ***
  • Posts: 160
    • View Profile
Re: Export to EXCEL does not Count
« Reply #3 on: March 24, 2016, 11:15:14 AM »
Thanks Bruce,

Will that ever make it into NT8?

poul

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Export to EXCEL does not Count
« Reply #4 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