We figured it out!! Your formula is correct and thank you soooo much for all your help. The issue we had was not in the formula but in some of our data. The 0 in column D we are now capturing as 1. Thank you again!!!