CODEWITHSUNDEEP
google-sheetscountinggoogle-sheets-querygoogle-sheets-formula
Jezun
Jezun

Reputation: 77

How to count from an entire different google sheet for only one cell?

I am counting the number of projects/rows from a different google sheet using a specific criterion. The total count will show in one cell only.

=COUNTIF(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1eDIDiMfE5bIi-hEVtwJ7t2wD7A5zTRSt2mHhoQ_mUrQ/edit#gid=359656787","HIP Campaign!H:H"),"Regular Campaign(Jan7-Feb21)")

HIP Campaign is the sheet name from the different google sheet link. H:H range is where you can find value like Regular Campaign(Jan7-Feb21). I need to count the number of rows which has the value of Regular Campaign in range H:H.

Upvotes: 1

Views: 44

Answers (1)

player0
player0

Reputation: 1

first, you need to link sheets by allowing access. run anywhere this formula:

=IMPORTRANGE("1eDIDiMfE5bIi-hEVtwJ7t2wD7A5zTRSt2mHhoQ_mUrQ", "HIP Campaign!H1")

when linked you can use:

=COUNTIF(IFERROR(
 IMPORTRANGE("1eDIDiMfE5bIi-hEVtwJ7t2wD7A5zTRSt2mHhoQ_mUrQ", "HIP Campaign!H:H")), 
 "Regular Campaign(Jan7-Feb21)")

Upvotes: 1

Related Questions