You should upgrade or use an alternative browser.

- Thread starter Jululian
- Start date

DearDear All,

May I kindly request that you amend or modify the formula to summarize the salary column as in (Yellow Cells)?

your help in this matter is highly appreciated

Regards

It's good to see you again. Thanks for sharing your problem with such clarity. I have reviewed your problem and devised a solution by enhancing your formula to reach your goal.

Follow these steps:

- Select cell
**H2**. - Insert the following formula:

=CHOOSE({1,2},

IF(IFNA(IF(ISTEXT((ROW(1:4)*500+1501)&"-"&((ROW(1:4))*500+2000)),FREQUENCY($B$2:$B$91, ROW(1:4)*500+2000), ""), "")<>"",(ROW(1:4)*500+1501)&"-"&((ROW(1:4))*500+2000),""),

IFNA(IF(ISTEXT((ROW(1:4)*500+1501)&"-"&((ROW(1:4))*500+2000)),FREQUENCY($B$2:$B$91, ROW(1:4)*500+2000), ""), "")

) - Hit
**Enter**.

Hopefully, you have the formulas you were looking for. I have attached the solution workbook as well. Good luck.

Regards

ExcelDemy

Last edited:

The support you have given me is greatly appreciated and your assistance has had a significant impact thank you In the future, if I want to adjust the genius equation from 500 to 1000, what should I modify?DearJululian

It's good to see you again. Thanks for sharing your problem with such clarity. I have reviewed your problem and devised a solution by enhancing your formula to reach your goal.

Follow these steps:

- Select cell
H2.- Insert the following formula:
- Hit
Enter.

View attachment 1405

Hopefully, you have the formulas you were looking for. I have attached the solution workbook as well. Good luck.

Regards

Lutfor Rahman Shimanto

ExcelDemy

DearThe support you have given me is greatly appreciated and your assistance has had a significant impact thank you In the future, if I want to adjust the genius equation from 500 to 1000, what should I modify?

Thanks for your kind words! Your appreciation means a lot to us.

If you want the interval, for example,

Don't worry! I have modified the previously given formula for your desired intervals. Please check the following:

- Select cell
**D2**. - Insert the following formula:

=CHOOSE({1,2},

IF(IFNA(IF(ISTEXT((ROW(1:21)*500+1)&"-"&((ROW(1:21))*500+500)),FREQUENCY($B$2:$B$91, ROW(1:21)*500+500), ""), "")<>"",(ROW(1:21)*500+1)&"-"&((ROW(1:21))*500+500),""),

IFNA(IF(ISTEXT((ROW(1:21)*500+1)&"-"&((ROW(1:21))*500+500)),FREQUENCY($B$2:$B$91, ROW(1:21)*500+500), ""), "")

) - Hit
**Enter**.

Hopefully, these ideas will help you. Stay blessed.

Regards

ExcelDemy

Last edited:

Thank you for the support you've given and your assistance has had a significant impact Many thanks on your great performanceDearJululian

Thanks for your kind words! Your appreciation means a lot to us.

If you want the interval, for example,501 to 1000,1001 to 1500, and so on, you need to make some changes. Within theISTEXTfunction, first, you must modifyROW(1:21)so that it iterates through rows 1 to 21 (it was1:4previously). Next, add "500+1" to get the intended intervals. Within theFREQUENCYfunction, make adjustments likewise for rows but add "500+500". So, get the point: adjustment will vary from the interval and dataset you use.

Don't worry! I have modified the previously given formula for your desired intervals. Please check the following:

- Select cell
D2.- Insert the following formula:
- Hit
Enter.

View attachment 1406

Hopefully, these ideas will help you. Stay blessed.

Regards

Lutfor Rahman Shimanto

ExcelDemy

DearThank you for the support you've given and your assistance has had a significant impact Many thanks on your great performance

Regards