CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulascountingcountif
hardy
hardy

Reputation: 557

How to count text based on other cell value in Google Sheets

How to count text in Google sheet based on other cell value, I want to count Column B if Column C indicates that Column B have Duplicate Value in Column E like bellow. How I can count text.

enter image description here

Upvotes: 0

Views: 2737

Answers (2)

player0
player0

Reputation: 1

D3 cell: 

=COUNTIF(C2:C, D2)

0

E3 cell:

=COUNTIF(C2:C, E2)

0

=ARRAYFORMULA(SUM(N(COUNTIFS(B2:B, B2:B, ROW(B2:B), "<="&ROW(B2:B))>1)))

0

Upvotes: 1

JPV
JPV

Reputation: 27302

In F2 try

=query(B2:C, "Select count(B) where B <> '' pivot(C)")

or if you want to count unique values for 'Done' and 'Duplicate' , in D3 try

=countunique(filter($B$2:$B, $C$2:$C=E$2))

and drag to the right for the duplicates count.

I hope that helps?

Upvotes: 3

Related Questions