Forum Discussion
Solved
Excel formula
Hi I have a column with 66 entries of different areas of m2. How can I sort these into 5 groups, ie. under 100, 100-500, 500-1000,1000-10,000, 10,000+. Thanks
You could create a pivot table based on the data.
Add the new column to both the Rows area and the Values area.
Or use formulas such as
=COUNTIFS(A2:A67, "<100")
=COUNTIFS(A2:A67, ">=100", A2:A67, "<500")
=COUNTIFS(A2:A67, ">=500", A2:A67, "<1000")
=COUNTIFS(A2:A67, ">=1000", A2:A67, "<10000")
=COUNTIFS(A2:A67, ">=10000")
Column BT.
The prior column shows total hours works @18, but column BT shows more hours
The prior column shows total hours works @18, but column BT shows more hours
The formula in BT3 is incorrect - it results in a negative number.
It should be
=(E3-D3)+(U3-S3)+(AK3-AI3)+(BA3-AY3)+(BP3-BO3)
As always Hans, your a legend.
Sometimes I just cant see the woods for the trees!
Thank you