CODEWITHSUNDEEP
syntaxgoogle-sheetscountif
Benjamin T. Halkier
Benjamin T. Halkier

Reputation: 1

Google Sheets COUNTIF syntax across different tabs

I am currently trying to work out how to make the current Google Sheets version of COUNTIF properly count how many times the value of a cell (C3) is higher than the value if another cell (E3), according to the following formula: 

=COUNTIF('4'!$C$3,">'4'!$E$3")

You'll note that the formula is run in a different tab than the one where the cells being counted are located in (which is named "4"). The formula returns a zero '0', when it should be returning a one '1', as the value in '4'!$C$3 actually is higher than the value in '4'!$E$3. Clearly, I am doing something wrong.

Upvotes: 0

Views: 276

Answers (1)

Benjamin T. Halkier
Benjamin T. Halkier

Reputation: 1

So, the user I'-'I (stackoverflow.com/users/8404453/i-i) suggested the following edit:

=COUNTIF('4'!$C$3,">'4'!$E$3") --> COUNTIF('4'!$C$3,">"&'4'!$E$3)

This suggestion resolved my issue.

Upvotes: 0

Related Questions