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

I can't check it right now, but


should work.


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!

gnumeric-list mailing list
gnumeric-list gnome org

Course View Towers,
Plot 21 Yusuf Lule Road,
T   +256 (0) 312 314 418
M +256 (0) 752 963 325

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]