Hi Folks,
I have a question, is there a way (a formula) that i can put in a first cell of a named column and have the formula sum the entire column EXCEPT the first cell of that same named range? This formula "=sum(index("My Named Range",,11))" results in a circular error because its trying to add in the same cell as im trying to put in the formula. Any help would be great!!
Fyi, column number 11 in the my named range is what i need totalled.
I have a question, is there a way (a formula) that i can put in a first cell of a named column and have the formula sum the entire column EXCEPT the first cell of that same named range? This formula "=sum(index("My Named Range",,11))" results in a circular error because its trying to add in the same cell as im trying to put in the formula. Any help would be great!!
Fyi, column number 11 in the my named range is what i need totalled.