how to tally rows and columns for 2 variables?

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

how to tally rows and columns for 2 variables?

bill-3
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
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|

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

Tim Schofield-4
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 <[hidden email]> 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
> [hidden email]
> 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
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|

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

GnuMeric mailing list
Happy to help :)

On Tue, 18 Jun 2019 18:07 bill, <[hidden email]> 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" <[hidden email]>
To: bill <[hidden email]>
Cc: Gnumeric <[hidden email]>
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 <[hidden email]> 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
> [hidden email]
> 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
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list