Hi all. First time posting.
Apologies if this question has been asked, I did search for it, but came up with nothing. It's a bit specific, and maybe too out there(?).
As the title says, I am looking for a fomula that will count an entire column for a specific term, but I want to exclude specific cells as well.
The reasoning for this is I have an Excel file that I am regularly adding to, and thought there must be a formula out there that will count the entire column so I don't have to alter the range each time I update. I should also explain the specific term part. Without going into too much detail, I use 0, 1 and 2 to differenciate the entries I am adding. So my formula currently uses this to look for any "0" entries in a range:
=COUNTIF(E13:E783,"0")
So if the range was replaced with the entire E column I would be set... HOWEVER, I need to exclude E1 to E12 as rows 1 to 12 are a frozen (non-scrolling) part of my file. So I need that part excluded.
Hopefully someone can help me!
Bookmarks