And if you just need the number without it being in a cell, you can
select a cell from any column in the first non-header row, then CTRL-D
to select everything down the column to the end of the data, and your
status bar should show you the result of COUNT(). If not, you can most
likely add it t
PM
> *To:* Murugan Muruganandam
> *Cc:* Jeff ; Gnucash userlist <
> gnucash-user@gnucash.org>
> *Subject:* Re: [GNC] easy way to total number of transactions and USD
> ammounts
>
> Jeff, I couldn't tie my response to what Murugan suggested.
>
> You can use the
Jeff, I couldn't tie my response to what Murugan suggested.
You can use the sum and count on the same spreadsheet. The Excel command
for count is =COUNTA(first cell:last cell) Just put that command in the
cell beneath the sum.
On Thu, Mar 30, 2023 at 3:29 PM Murugan Muruganandam <
m.murugana
hi Jeff
I would suggest the best will be to generate the transaction report
in options
Account:select all account
Display: select account name , unselect full name
Display: Amount as single column
General: date range and check table for export
export the report to .xls format and open it in the
Jeff,
It looks like your best bet is a Transaction Report that you then export
to a spreadsheet app.
An enhancement to show the count of results on a Find operation might be
nice though. You could then use that info with an Account Report on Find
results.
Regards,
Adrien
On 3/30/23 1:43 A
Hi Jeff/all,
I encountered this issue a few weeks ago for a tax client with a short
term rental property. Apparently, 2022 is a "transition" year for the
new requirements for producing a form 1099K -
https://www.irs.gov/businesses/understanding-your-form-1099-k
This VRBO page might be easier
