Sep 15 2020 02:23 PM
Sep 15 2020 02:34 PM
Perhaps you may provide small sample file with manually added desired result, so far it's not very clear what is required.
Sep 16 2020 01:32 AM
@Sergei Baklan Thanks. I've added this spreadsheet with the correct result in the bottom cells. I hope this makes more sense.
Thanks
Sep 16 2020 02:15 AM - edited Sep 16 2020 02:19 AM
Nothing wrong with formula in cell B24 & C24. Also formula in B26 working properly,, you have not dragged the formula in C26, otherwise in both cells you get 3 BEG,,, now let me say I'm unable to realize what exactly you are looking for,, please be specific all about the issue.
Sep 16 2020 04:26 AM
Sep 16 2020 07:11 AM
I'd suggest to add helper range in any place of your workbook as
with it formula could be
=LOOKUP(SUM(B$5:B$22),$G$7:$G$12,CHOOSE(((B$5+B$6)>=6)+1,$H$6:$H$11,$H$7:$H$12))
which returns
Sep 16 2020 01:20 PM
Sep 16 2020 11:22 PM