Help! I have a formula that currently reads COUNTIF('SheetOne'D$3:D$1506,A2). The next row is COUNTIF('SheetOne'D$3:D$1506,A2) +COUNTIF ('SheetOne'D$3:D$1506,A2). The formula works perfectly but unfortunately I need to go all the way down to A1517 adding an extra row each time.... Is there another way round this to get the same result but save me entering this 1517 times?!?

Thank you so much if you can help me!