For some reason why I use countifs, I get a parse error when adding the criterion to be a greater or less than. If I put a whole number, I do not receive the parse error.
Here is the code that works =COUNTIFS(Boxscores!B1:B1000, "ana", Boxscores!C1:C1000, 2)<--successful with this code This is what I need =COUNTIFS(Boxscores!B1:B1000, "ana", Boxscores!C1:C1000, >2) <--parse error with this code I have tried putting the >2 into " but I still receive parse error. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
