Jan 07 2023 10:26 AM
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.
Jan 07 2023 11:09 AM
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.
Jan 07 2023 12:06 PM
Thank you, I'll do it this way.