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)))
Would =+COUNTIF(A:A,B1) not work if B1 is the cell left of your countif and A:A is the data range? We need some more info on the structure of your data.
Thanks, but I actually just figured it out!