CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Lizi1990
Lizi1990

Reputation: 103

how to find the count of peoples according to the date

here I want to know can we find the total peoples present on that specified date? that if we enter the date on the next sheet we need to display the count of peoples present on that day. An example is there on the sheet 2.

https://docs.google.com/spreadsheets/d/1TxScKc0NT2pB9ytpyMcq99nYmirS5NAPnRGNtACyaeE/edit#gid=0

thanks in advance

Upvotes: 1

Views: 50

Answers (1)

player0
player0

Reputation: 1

use:

=QUERY({Sheet1!A2:B}, 
"select Col1,count(Col2) where Col2 is not null group by Col1 label count(Col2)''")

update:

=ARRAYFORMULA(IFNA(VLOOKUP(A2:A, QUERY({Sheet1!A2:B}, 
"select Col1,count(Col2) where Col2 is not null 
 group by Col1 label count(Col2)''"), 2, 0)))

Upvotes: 2

Related Questions