In a column headed "Fred Count" I have the formula =COUNTIF(L$2:L10,"Fred") in row 10 where column L is headed "Person" and contains various names, so as I drag the formula down the "Fred Count" column it shows the number of times Fred appears in Person column at the current row or above.

How do I write the formula to use the table nomenclature? I've tried various combinations, but haven't hit on theone that works.

tia

`[[#All][Person]]`

? There is no way for that. You can use only if you refer to the current row, or the whole column. – Máté Juhász Feb 17 '17 at 13:17`ADDRESS`

and`INDIRECT`

functions, but this would make your formula too complicated). Maybe you could use this one:`=COUNTIF(OFFSET([@[Person]],-(ROW()-2),0,ROW()-1,1),"Fred")`

. – Máté Juhász Feb 17 '17 at 13:55