Re: how to tally rows and columns for 2 variables?

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