Hello i am trying to find a way to take the below countifs statement and update it to where through the range D23 to D8622 it counts the number of "X"s where the cells in the range B23 to B8622 equal "Section Mark X"
there are multiple cells down the B range where the cells have Section Mark X and they start from 24, the next one is 67, 110, 153 so about every 43 cells down and 2 columns down there may be an X so D24, D67, D110, but its not guaranteed that there will be an X
=COUNTIFS(D$23:D$8622,"X")
example if there was the sheet like this below the count looking for is 4 since there is 4 X for every section mark X cell
there are multiple cells down the B range where the cells have Section Mark X and they start from 24, the next one is 67, 110, 153 so about every 43 cells down and 2 columns down there may be an X so D24, D67, D110, but its not guaranteed that there will be an X
=COUNTIFS(D$23:D$8622,"X")
example if there was the sheet like this below the count looking for is 4 since there is 4 X for every section mark X cell
Section Mark X | X |
Section Mark X | X |
Section Mark X | |
Section Mark X | |
Section Mark X | X |
Section Mark X | X |