CountIF for greater than numbers

[tanishmittal]

Need help for workflow of COUNTIFS where in the count of values above 2 is required based on Names.

Below solution would be: A with a count of 2 values greater than 2, B with a count of 2, C with a count of 0

For eg:

Name	Value
A	2.5
B	4
C	1.1
A	1.5
A	1.2
A	3.7
B	4.4
C	1.1

[atcodedog05 · Accepted solution]

Hi @tanishmittal 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Emil_Kos · Accepted solution]

Hi @tanishmittal,

I have prepared a workflow for you:

And the output:

If this is something helpful please mark as a solution!

Good Luck!

[atcodedog05]

Hi @tanishmittal 

Guessing this is how excel output will look like hence giving this approach.

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Emil_Kos]

Hi @tanishmittal,

Thank you for marking my post as a solution.

Good Luck!

[atcodedog05]

Happy to help 🙂 @tanishmittal 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂