Forum Discussion
Solved
Creating a COUNTIF formula that always references one cell to the left
Hello! I'm working on a project that involves using a COUNTIF statement which will always reference the cell directly to the left of it. I'm trying to figure out a way to automate the process, b...
- So, I've answered my own question,
What I ended up doing was creating an OFFSET statement within the COUNTIF function,
=COUNTIF(A1:A10000, (OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)))
So, I've answered my own question,
What I ended up doing was creating an OFFSET statement within the COUNTIF function,
=COUNTIF(A1:A10000, (OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)))
What I ended up doing was creating an OFFSET statement within the COUNTIF function,
=COUNTIF(A1:A10000, (OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)))