hey everyone i am trying to figure out the formula to allow me to count the number of times a word "open" appears if the text in column A matches the text in sheet 2 column A then counting the number of times "open" appears in sheet 2 column G
<tbody>
<colgroup><col...