Re: Tallying entries by row and column
bill <[email protected]>
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <trinity-7f5d86c3-a299-4fd6-838b-3a1a89234c0b-1528778909909@3c-app-mailcom-lxa01> |
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" <[email protected]> To: [email protected] Cc: "Gnumeric Mailing List" <[email protected]> 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 _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list