I have a formula in my worksheet:
COUNTIF(F:F, "Pass")
I want this formula to ALWAYS refer to F:F, even if more columns are inserted. How do I do this?
I have a formula in my worksheet:
COUNTIF(F:F, "Pass")
I want this formula to ALWAYS refer to F:F, even if more columns are inserted. How do I do this?
Never mind. I figured it out.
COUNTIF($F:$F, "Pass")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks