Hi There,
In my attached sheet I am looking to find a formula where I can get the result of HD if its greater than or equal to 3=0. However,i have defined HD =0.5. but if somebody takes 3 consecutive HD it should be counted 0 .
I hve tried with formula sumproduct(sumif) but unable to get result. Please guide me to understand.
Thanks,
Madhoor
▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !
In my attached sheet I am looking to find a formula where I can get the result of HD if its greater than or equal to 3=0. However,i have defined HD =0.5. but if somebody takes 3 consecutive HD it should be counted 0 .
I hve tried with formula sumproduct(sumif) but unable to get result. Please guide me to understand.
Thanks,
Madhoor
▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !