Forum Discussion

Copper Contributor

Mar 12, 2022

Solved

Help me to find the function to do this (Count values with matching condition)

I have this data, and i want to count the numer of data that appears in the left (no counting same data [DISTINC]) for each number in the right column, and the most important, do the operation in one cell.

I tried ifs conditions, count.if, sum.if but i can't do the counting in one cell, it does the operation for the 20000 rows. It's like i need to do a counter, but i don´t know how to do it.

Thank you in advance.

BI & Data Analysis

excel

Formulas and Functions

office 365

OliverScheurich
Mar 12, 2022
Chelu13
=COUNTA(UNIQUE(FILTER($A$1:$A$11,$B$1:$B$11=D1)))
Is this what you are looking for?

2 Replies

Chelu13
Copper Contributor
Mar 12, 2022
Thank you Quadruple_Pawn, exactly this is what i was looking for, i didn't think about counta, to count the spaces that are not in blank, so thank so much!!
OliverScheurich
Gold Contributor
Mar 12, 2022
Chelu13
=COUNTA(UNIQUE(FILTER($A$1:$A$11,$B$1:$B$11=D1)))
Is this what you are looking for?