D deanster Joined Sep 18, 2015 Messages 1 Reaction score 0 Sep 18, 2015 #1 In excel 2010 can I use a renamed line in a formula. example: =COUNTIF(B11:All_Users,"Total")