Need help with Excel formula

New 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

@Vladtok05 

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.

S2130.png

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.