Thank you Morten!
Yes, i did mean F52, glad my mistake didn't trip you up.
I *think* i did as you instructed, but it only copied =counta(G50:DZ50) into F51 without changing the values 50 to 51. Also, it ignored the remainder of the column i had selected.
Trying something similar, i did find i can select F50 (the last cell that contains the formula) downward as far as i need, then from the toolbar use Data-Fill-Fill Downwards. This worked perfectly, filling each cell with the formula, corrected for row number.
A big thank you as i would not have discovered this without you setting me on the path! MUCH time will now be saved in my projects.
peace
bill
Sent: Sunday, June 10, 2018 at 6:08 PM
From: "Morten Welinder" <mortenw gnome org>
To: billd post com
Cc: "Gnumeric Mailing List" <gnumeric-list gnome org>
Subject: Re: Tallying entries by row and column
> For instance i am putting =counta(G50:DZ50) in F50, =counta(G51:DZ51) in F51, =counta(G52:DZ52) in G52
I assume you meant F52, not G52.
That should be quite easy to enter Once you have put
=counta(G50:DZ50) into F50, select the cell and press Ctrl-C for copy.
Then select F51 through F100 -- as far as you want -- and press
Ctrl-V. That's it -- you're done.
Morten
