Hello everybody !
I would once again need your help for a Excel problem !
I want to solve the following numbers problem.

I attached my excel file to this post.

The A-J rows each contain 10 random numbers from 1-20.
I need a formula in the solutions rows that would automatically fill the cells with the numbers from above , following the conditions written in the red solutions column.
The 1st solution should be the numbers from A+B
The 2nd solution should be the numbers from B+C etc...

Thank you very much !!!

Put this formula in cell B18 and copy it across to cell U18, then copy all of those cells (range B18:U18) down to Row 26...

=IF(B3&B4="","",B\$1)

I did note some errors in the example solution you posted.

Thank you very much !
It works great !!!
Yes , you are right , now I notice some errors as well. That`s why a formula was needed , it`s very easy to make a mistake checking so many numbers.

Now I have another little problem.
I would like to add a formula in the V column that counts how many numbers are in each ''solution''. I tried to do it like this: =COUNTA(B18:U18) , however I get the result 20 when the result should be 13.
I`m assuming the counta counts your formula inside each cell as a result instead of counting the numbers ???
Any ideea how to fix this ?
Thank you very much !!!

Originally Posted by Rick Rothstein
Put this formula in cell B18 and copy it across to cell U18, then copy all of those cells (range B18:U18) down to Row 26...

=IF(B3&B4="","",B\$1)

I did note some errors in the example solution you posted.

try it this way... =COUNTIF(B18:U18,">0")

Actually, just using COUNT should work...

=COUNT(B18:U18)

Thank you very much Sam Capricci !!!
Thank you very much Rick Rothstein !!!

There are currently 1 users browsing this thread. (0 members and 1 guests)