[GNC] easy way to total number of transactions and USD ammounts

Adrien Monteleone adrien.monteleone at lusfiber.net
Thu Mar 30 20:38:18 EDT 2023


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 to the status bar.

Regards,
Adrien

On 3/30/23 4:44 PM, Phyllis Bruce wrote:
> 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.



More information about the gnucash-user mailing list