COUNTIFS function on google sheets

[SLVoyou]

=COUNTIFS(G3:G57="D60",A3:A57="★")

This is currently what I have, and for some reason it just always equals 1.
I know the formula works a little differently in google sheets than in drive, but if someone could please give a hand that would be great.

Also; that star is actually a star -- not "*" for containing any text. This might be the issue I guess since it is an alt code.

Thank you!

 

[Noodleski]

Not having worked with google sheets, but the syntax is quite different from ordinary excel. Sure that that is right?

I'd expect something more like:

=COUNTIFS(G3:G57,"D60",A3:A57,"★")

 

[SLVoyou]

Oops you're right.
When I changed it to that, they went to 0 with no errors -- but when I try testing it, the 0 never changes.

 

[Noodleski]

I'm not familiar with that star-thingy you're using. Could you substitute the star with a more normal character and test the formula again.

 

[SLVoyou]

Yeah I'm testing with regular letters and it stilll isn't working.
=COUNTIFS($G$3:$G$57,"D60",$A$3:$A$57,"FB")

 

[SLVoyou]

=COUNTIF(A3:A57,"FB") in one cell yields 1
=COUNTIF(G3:G57,D60) in another cell yields 1
=COUNTIFS($G$3:$G$57,"D60",$A$3:$A$57,"FB")yields 0

 

[SLVoyou]

I just realized now that there's no way of specifying what I'm actually wanting.

I want it to count rows where the A and G column both fit the criteria.

 

[Noodleski]

I just realized now that there's no way of specifying what I'm actually wanting.

I want it to count rows where the A and G column both fit the criteria.

Ok, but then the formula would make sense, unless there is not a single row which holds both 'FB' in the A range as "D60" in the G range?

I just noticed that in your test, you actually typed an error. You forgot the quotation marks on the second countif:

=COUNTIF(A3:A57,"FB") in one cell yields 1
=COUNTIF(G3:G57,D60) in another cell yields 1
=COUNTIFS($G$3:$G$57,"D60",$A$3:$A$57,"FB")yields 0

As a result, your countif matched range G3:G57 against the value in D60, not against 'D60'.