Happy to help :) On Tue, 18 Jun 2019 18:07 bill, <[email protected]> wrote:
> Tim, > > A belated thank you for the formula. I finally had a chance to get back to > the project where it was needed, and it works great! > > peace > bill > > *Sent:* Tuesday, June 11, 2019 at 3:22 AM > *From:* "Tim Schofield" <[email protected]> > *To:* bill <[email protected]> > *Cc:* Gnumeric <[email protected]> > *Subject:* Re: how to tally rows and columns for 2 variables? > I can't check it right now, but > > =COUNTIF(G3:G2030,"x")+COUNTIF(G3:G2030,"y") > > should work. > > Tim > > On Tue, 11 Jun 2019 at 07:58, bill <[email protected]> wrote: > > > > Hi all, > > > > I have a column and row near the beginning of my spreadsheets that > counts each x i insert into the cells of that column or row. For that i use > the formula =countif(G3:G2030,"x") for the G column, and etc. Suddenly i > have need to also count any y in that table. I tried adding to the formula > so that it reads =countif(G3:G2030,"x","y"), but get the error that there's > too many variables for the countif statement. I'm sure there's a simple fix > that i just can't seem to ferret out. Any ideas much appreciated! > > > > bill > > _______________________________________________ > > gnumeric-list mailing list > > [email protected] > > https://mail.gnome.org/mailman/listinfo/gnumeric-list > > > > -- > Course View Towers, > Plot 21 Yusuf Lule Road, > Kampala > T +256 (0) 312 314 418 > M +256 (0) 752 963 325 > www.weberpafrica.com > @TimSchofield2 > Blog: http://weberpafrica.blogspot.co.uk/ >
_______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
