How to CountIF specific same text and total it in another tab in the same googlesheet

user_17384355 0
Viewed 22

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!

countif counting google-sheets
1 Answers

try:

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