Gnumeric COUNTIFS?
by SUSESailor from LinuxQuestions.org on (#6E3KN)
Hello!
I was wondering if anyone knew a workaround for the apparent lack of a COUNTIFS function in Gnumeric. I am trying to write an algorithm that counts all rows in which certain values exist in two of the columns, which based on my research would be done using the COUNTIFS function, because it permits the conditional AND to look at multiple values before returning a TRUE. When I write the function using COUNTIFS, however, I get a #NAME! error.
I'm guessing that Gnumeric doesn't have COUNTIFS..? If it doesn't, does anyone know of a way that I can still get the multiple comparison row count?
Thanks in advance!
SUSESailor
I was wondering if anyone knew a workaround for the apparent lack of a COUNTIFS function in Gnumeric. I am trying to write an algorithm that counts all rows in which certain values exist in two of the columns, which based on my research would be done using the COUNTIFS function, because it permits the conditional AND to look at multiple values before returning a TRUE. When I write the function using COUNTIFS, however, I get a #NAME! error.
I'm guessing that Gnumeric doesn't have COUNTIFS..? If it doesn't, does anyone know of a way that I can still get the multiple comparison row count?
Thanks in advance!
SUSESailor