I want to calculate the same text/value in the entire columnA of Tab1 and calculate the Total in a single cell in Tab2, but on the same sheet in googlesheet:

I enter image description herecurrently built this code;

=COUNTIF("Ads Sharing!B2:B", "<>Christian")

Let me know if this is possible in googlesheets, Thanks in Advance!

CodePudding user response：

try:

=COUNTIF('Ads Sharing'!B2:B, "<>Christian")