I am trying to make it so that if the value of (P2:P73) = yes, and the value of (Q2:Q73) = no, it counts as 1 entity in L86. This is a little tough to explain because I can't explain the entire project I am working on as it is work-related. Essentially, say a meeting that was held went well, no issues, and it started in 60 seconds. I want to count every meeting that went off without any issues. So, if P2's value is "yes" and Q2's value is "no", L86's value will increase by 1, as it is showing 1 meeting that went perfect. Is there a way to use IF AND statements to achieve this?
I appreciate any help so thanks in advance! Also, I am new to this forum so let me know if my attachment did not go up. Most of the information is hidden in the screenshot for privacy reasons, but everything needed to answer this should be on there. Thanks so much
Bookmarks