Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Need help with Excel formula

Copper Contributor

Can somebody help me with this task:
How many products were sold in weight ranges of 100 gram increments?

I have a table with data in weight formatted to grams and I need to find a formula to answer this question.

2 Replies


You can use the FREQUENCY function for this.

Let's say the weights are in A2:A37, and they go up to max 800 gram.

Create a list of weights 100, 200, ..., 700 in a column.

Select the cells to the right of the list plus one more.

Enter the formula =FREQUENCY(A2:A37,C2:C8)

If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.


The last cell in the result is the number of entries above 700 gram in this example.

@Hans Vogelaar

Thank you, I'll do it this way.