Re: how to tally rows and columns for 2 variables?
- From: Tim Schofield <tim weberpafrica com>
- To: bill <bill samerica com>
- Cc: Gnumeric <gnumeric-list gnome org>
- Subject: Re: how to tally rows and columns for 2 variables?
- Date: Tue, 11 Jun 2019 09:22:10 +0100
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 <bill samerica com> 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
gnumeric-list gnome org
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/
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]