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
