Check if cell is empty then check next

Hi
I have a little problem regarding an excel formula. I want to check a row if one cell is empty then i want to check the next cell in the same row and if it is empty then to check the next row until a number is found
When a number is found i want the number of this cell to be divided with a different cell

Can you please help me???

Thank you so much in advance

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

Hi.

Thank you so much for your reply but it doesn't seems to work

for example:
τεστ.png

I have that table with sales per code and the sum at the end. I want a function that will find the first cell that its not empty and divided by the sum at the end of a row. For example for the first row 727/17192 for the second row 73/3314 and so on.

Can you please help me??
Thank you so much in advance!!!!

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results.

I showed you hw the first non empty cell could be found. but not whole formula. If the table from A to S then

Formula:

Please Login or Register  to view this content.

Thank you very much but i get a #value as a result. Do you know why and how to fix it???

Post a small Excel sheet (not a picture) showing realistic & representative sample data

Where is file?

Hi.

I have attached an example

Thank you very much again

Sorry. I forgot to say it is array formula and finished by Ctrl+Shift+Enter

Thank you sooooooo much!!! Its really working!!! Amazing!!!
When i am adding a row though the function stops working. Do you know why?? What should i change??

May be because of

it is array formula and finished by Ctrl+Shift+Enter

Do you know how to fix it???

Thank you very much!!!!