COUNTIF work arounds for SharePoint lists

Question

I've looked at the following questions already posted in this forum, but neither quite address the specific issue I'm having.

Can I create a COUNTIF calculated column in SharePoint? How can I build a CountIF function in SharePoint?

I am wondering if SharePoint allows you to reference a certain cells data to then look that value up in a column and count how many of that value there are. These would not be set values, which is why the workarounds proposed in the articles above are not working for me.

EX:In our Excel sheet that we are putting into SharePoint, we are using this formula =COUNTIF($C$2:$C$2007,C2007) and we are trying to translate this into SharePoint.

As shown in the image I've attached, we want a frequency column to calculate how many times each value in the Values column occurs. So the results would end up looking like what's in the image.

Sample Table with Desired Results

Answer 1

Based on my research, SharePoint does not support CountIF function, it is by design.

However, you can use "Group By" as a workaround:

1.Go to the list and click on All Items >> Edit current view

2.On the Edit View page, scroll to "Group By" section and select column that your wanted.