how to tally rows and columns for 2 variables?
bill <[email protected]>
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <trinity-6497fcc1-736d-4b4f-bdac-05b44ad8c4c6-1560236280296@3c-app-mailcom-lxa11> |
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