Forum Discussion
Solved
Counting duplicates in a separate tab, filtering the adjacent column by the text in a cell
Good evening. I am using Office 365. Please see attached. I'm trying to do this: Depending on the text in USE:B2, filter SITES: B:B by that text, then count cells in SITES: C:C which are duplicat...
How about
=SUM(--(IF(SITES!B3:B13=B2,COUNTIFS(SITES!B3:B13,B2,SITES!C3:C13,SITES!C3:C13),0)>1))
=SUM((SITES!$B$3:$B$13=B2)*(SITES!$D$3:$D$13="Multiple Desk Setup"))
- Thank you for your help, but I am trying to count the duplicates in the C column, not the D column. It actually serves a different, and equally valid, purpose for me than counting the duplicate "Multiple Desk Setups" does.
How about
=SUM(--(IF(SITES!B3:B13=B2,COUNTIFS(SITES!B3:B13,B2,SITES!C3:C13,SITES!C3:C13),0)>1))
- That worked. Thank you!
