How to count columns based in the active cell

[Anapaz]

Hi guys,
I have a particular problem where I need to count always columns based in the raw after the active cell and return the result for an specific cell.

For example, here below I need to count from column 1 to column 3, having as active cell column 1, raw 1. So as the active cell is in column 1, raw 1, the count must be from raw 2 to column 3 and return the count for column 1, raw 3.

Column 1 | Column 2 | Column 3 |
Raw 1 |"active cell"| | |
Raw 2 | 1 | 2 | 3 |
Raw 3 | | | |

Thanks!

 

[Anapaz]

________Column 1 | Column 2 | Column 3 |
Raw 1 |"active cell"|_________|_________|
Raw 2 |____ 1 ____|___ 2___ |____ 3___ |
Raw 3 |__________|_________|_________|