This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I need to count cells, like A2 + 4 cells = A6. How can I put this in a formula?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
It appears that you want to obtain the row number of a cell for calculations. You can consider using the ROW function to get the row number of the target cell.
Thomas
Didn't work. =OFFSET(A2,19,0) just seems to put whatever you put in the second parameter. Almost everytime. No, I want to "math" with the cells.
Like A2 + 5 = A7. For instance as an example, B6 = "Sunday", so to find the next sunday, it would be B6 + 7, right? Which would then be in cell B13. B6 + 7 = B13.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Perhaps:
=OFFSET(A2,4,0)
No, this is not it at all. Like I said, I want to be able to have it select value from a cell, based on a cell plus a number to get to that cell. The example is given: A2 + 4 = A6. Is there a way to do this? Not COUNTA, that counts cells with value. That's not it. Or even if it was..
Then A2 + COUNTA(B2:B5) = A6 (given all B2:B5 has a value in them). I want to have it count to a cell, then use that value.
Hi Stefan Walle,
Thanks for your post in Microsoft Community.
I'm not quite sure about your exact needs. Are you trying to count the number of cells containing numbers between A2 and A6? If so, you could consider using the COUNTA function:
=COUNTA(A2:A6)
Please share more context with me so I can assist you better, and I look forward to your reply!
Best Regards,
Thomas C - MSFT | Microsoft Community Support Specialist