Forum Discussion
Solved
COUNTIF help
Hi all, I'm running a COUNT IF in a table, receiving data input from Forms. The info is and will continue to come in for a long time yet. The formula I'm using is =COUNTIF($D$2:D2,D2) As i pro...
You may replace your formula with the following one to make it work with the self expandable range reference.
=COUNTIF(D$2:INDIRECT("D"&ROW()),D2)
You're welcome brentonhobden! Glad it worked as desired.