Hello Friends,
I am using this formula in a worksheet on 120 cells. And the sheets is set to hide/unhide rows based on the results.
The formula is giving correct result but it is taking 4 to 5 seconds for the sheet to hide/unhide rows.
Can anyone pls suggest another option that I could replace the below formula with which would work faster
Regards,
Humayun
I am using this formula in a worksheet on 120 cells. And the sheets is set to hide/unhide rows based on the results.
The formula is giving correct result but it is taking 4 to 5 seconds for the sheet to hide/unhide rows.
Can anyone pls suggest another option that I could replace the below formula with which would work faster
Excel Formula:
=SUMPRODUCT(SUMIFS(r_daily_production_cutting,r_daily_production_po,$U$8:$U$22,r_daily_production_date,$B228))
Regards,
Humayun