SOLVED

New Contributor

# 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, because I have hundreds of these unique values that occur thousands of times throughout the sheet, but I don't want to have to spend the time to plug in a specific reference for each value. I'm hoping someone can help out!

Clyde

3 Replies

# Re: Creating a COUNTIF formula that always references one cell to the left

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.

# Re: Creating a COUNTIF formula that always references one cell to the left

Thanks, but I actually just figured it out!
best response confirmed by allyreckerman (Microsoft)
Solution

# Re: Creating a COUNTIF formula that always references one cell to the left

So, I've answered my own question,
What I ended up doing was creating an OFFSET statement within the COUNTIF function,