I can drag the little blue icon on the bottom of G7, drag to the right, and it will copy the formula to the next cells it automatically increments, so the formula in H7 is "=countif(H2:H6, true)"

Posters: RichDecibels. RichDecibels

2 likes recorded by the source corpus.