kamnashah✭

Thanks Parul that was very helpful

Hello Carson, That worked. Thank you so much for all your help.

Thank you for your response Parul. To provide you better details, the below are the two sheets ... Essentially, the formula should show the value of 5 for Customer Number 836374 in "Sheet AA". The formula I used is =COUNTIFS({Sheet BB Range 2}, "Yes", [Customer Number]@row, {Sheet BB Range 3}) Range 2 is column…