python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - countif

Googlesheets count single cell across multiple sheets

Looking for a formula that will count the value of a single cell across multiple (a whole class of students) sheets. I am aware of using + to do this but for 30 students I'd want something more dynami...
test-img

Mr L Fenner

arrays

google-apps-script

google-sheets

countif

google-query-language

Votes: 0

Answers: 1

Latest Answer

either you hardcode it like: =COUNTIF({Anthony!$A1,Lee!$A1,Cornelius!$A1,Liam!$A1}, B1) or use script: function SNAME(option) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.get...
test-img

player0

Google sheets: Is there a way to quickly/easily add a date range to ~300 cells each with different countifs formulas?

I am using the countifs function to add up a lot of different conditions - I need help to simplify the process so that it doesn't require so much manual formatting every time. Here is a screenshot of...
test-img

Carole Spake

google-sheets

excel-formula

google-sheets-formula

countif

Votes: 0

Answers: 1

Latest Answer

use: =INDEX(QUERY(QUERY({A2:A, PROPER(B2:C), IF((E2:E="yes")*(F2:F<>"yes"), 1, 0), IF((E2:E="yes")*(F2:F= "yes"), 1, 0)}, "select Col2,Col3,sum...
test-img

player0

Unable to get COUNTIF in vba function working

Can someone shed some light on why the countif statement below fails ? I can see in the debugger that the range "CountRange" has a value in row 90 of "COL0117". I am using the coun...
test-img

Simon Phillips

excel

vba

countif

Votes: 0

Answers: 1

Latest Answer

Simplified to show the basic approach: Sub tester() Debug.Print LookupExternalData("C:\Temp\SO2\blah.xlsx", "Project0008", 4) End Sub Function LookupExternalData(ByVal FileP...
test-img

Tim Williams

How do I select from UNIQUE and COUNTIF by data in adjoined column?

Starting with this list of countries and dates: date country 01.04.2022 Norway Sweden Norway 02.03.2022 Denmark 03.03.2022 Norway I want to pick the UNIQUE countries from the lis...
test-img

Espen

google-sheets

unique

countif

Votes: 0

Answers: 1

Latest Answer

This is the kind of thing that QUERY() is designed for. In a brand new tab in cell A1 =QUERY(Sheet1!A:B,"select B,COUNT(B) where A is not null group by B order by COUNT(B) desc") or if you...
test-img

MattKing

Posts

Questions

Blogs

Jobs