Use formula in place of row number?

Good call. Heres an example of what i'd like to be able to do. The term sheet contains entries for every occurrence of particular terms. Article sheet counts the terms by articles. There are a number of other data points for each entry in the term sheet but the mechanics are the same. There will ultimately be hundreds of entries in the term sheet and probably about 50 articles. Problem with the countif( function is caused by the variable ranges for each article (since the number of relevant terms in each article varies significantly). Open to any suggestions. Thanks in advance.