• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel formula help

Status
Not open for further replies.

Maddy

Member
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 !
 

Attachments

  • Sheet.xlsx
    9.8 KB · Views: 0
Status
Not open for further replies.
Back
Top